title: How to determine total number of open/active connections in ms sql server 2005
body: <p>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</p>