MS SQL Server - Measuring Login Times

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Measuring Login Times

MGeles

2006-10-31, 12:15 am

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 to
capture this info
TIA
--
MG

stavros

2006-10-31, 12:15 am

MGeles 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 to
> 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

Sponsored Links