Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have an SQL Server 2005 that is the backend of a web application.

The application is partly SharePoint and partly web services accessing the database via Entity Framework.

In the performance monitor I am seeing average SQL Logins is ca, 60 per second (max 170), but the average logouts is less than 1.

Where can I see the total number of SQL Server logins? Anyone have an idea what could be causing this?

share|improve this question
up vote 1 down vote accepted

It could be that the application creates connections during page loads but never terminates them, thus they hang around until they time out/expire.

I would start by setting up a SQL Profiler trace of the SQL Server which will show you logins and logouts. This will let you see where logins are coming from with unmatched logouts. The standard profiler template will include logins and logouts, but has some other things included with it that might just be noise for what you're looking for. You can remove the other events from the trace in order to focus just on the logins/logouts.

Have a look at Using SQL Server Profiler on MSDN for more detailed info on the Profiler. It is of high value when troubleshooting SQL Server issues.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.