Any tools or methods to monitor the speed between web and ..

I want to know are there any free tools or simple methods
that I can monitor the speed between my web server(IIS
5.0) and my db server(SQL Server 2000) in application
level.(not network level) I mean how I know my ASP program
is connecting to db to get the needed data in a resonable
speed. I want to figure out what really causes the speed
slow down - newwork or application factor. (Of
Course,appication factor maybe include network factor.)
Thanks!!

I'm not completely sure i understand what kind of information you are
looking for, but if it is database performance i think that you can get
everything you want using SQL Profiler (you can find it together with all
the other SQL Server tools). It can give you information about duration,
start time, what was done and by who (and alot of other things).

This will give you enough information to find out if you have a problem in
the DB, with slow stored procedures, or other things.

--
Regards,
Kristofer Gafvert - IIS MVP
Reply to newsgroup only. Remove NEWS if you must reply by email, but please
do not.
<a style='text-decoration: underline;' href="http://www.ilopia.com" target="_blank">www.ilopia.com</a> - FAQ and Tutorials for Windows Server 2003


"Jackson Cheng" <kycheng DeleteThis @cht.com.tw> wrote in message
news:13a0601c3f77a$8cd3fe00$a601280a@phx.gbl...
 > I want to know are there any free tools or simple methods
 > that I can monitor the speed between my web server(IIS
 > 5.0) and my db server(SQL Server 2000) in application
 > level.(not network level) I mean how I know my ASP program
 > is connecting to db to get the needed data in a resonable
 > speed. I want to figure out what really causes the speed
 > slow down - newwork or application factor. (Of
 > Course,appication factor maybe include network factor.)
 > Thanks!!<!-- ~MESSAGE_AFTER~ -->