How to monitor the total number of SQL Server logins

Posted by Shiraz Bhaiji on Server Fault See other posts from Server Fault or by Shiraz Bhaiji
Published on 2010-03-23T16:28:19Z Indexed on 2010/03/23 16:33 UTC
Read the original article Hit count: 204

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?

© Server Fault or respective owner

Related posts about sql-server-2005

Related posts about login