Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.