My PHP/MS Sql Server 2005/win 2003 Application occasionally becomes very unresponsive, the memory/cpu usage does not spike. If i try to open any new connection from sql management studio, then the it just hangs at the open connection dialog box.
how to deterime the total number of active connections ms sql server 2005
Sql-server – How to determine total number of open/active connections in ms sql server 2005
connectiondatabasesql serversql-server-2005
Related Topic
- Sql-server – How to check if a column exists in a SQL Server table
- Sql – How to concatenate text from multiple rows into a single text string in SQL Server
- .net – How to solve a connection pool problem between ASP.NET and SQL Server
- Sql – How to do an UPDATE statement with JOIN in SQL Server
- Sql – How to UPDATE from a SELECT in SQL Server
- Sql-server – How to specify a port number in SQL Server connection string
- Sql – How to delete using INNER JOIN with SQL Server
- Sql-server – Cannot Connect to Server – A network-related or instance-specific error
Best Answer
This shows the number of connections per each DB:
And this gives the total:
If you need more detail, run:
Note: The SQL Server account used needs the 'sysadmin' role (otherwise it will just show a single row and a count of 1 as the result)