Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesI'm looking for a way to measure how long it takes to log into a SQL 2005 server from a web server running IIS 6. Does anyone have any ideas? I've tried using the Profiler, but I haven't been able to think of a way to capture this info TIA -- MG
Post Follow-up to this messageMGeles wrote: > I'm looking for a way to measure how long it takes to log into a SQL 2005 > server from a web server running IIS 6. Does anyone have any ideas? > I've tried using the Profiler, but I haven't been able to think of a way t o > capture this info > TIA > -- > MG AFAIK, SQL 2005 tracks only when a login is successful or unsuccessful, not the time it takes to make the connection. You may need to use a network sniffer to capture traffic between the servers, if that's what you're trying to measure. Stavros
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread