title: find number of open connection on database
body: <p>My web application is in asp.net 2.0,c#2.0 and sql server 208 how can i find number of open connections on my sql server 2008 database.and is there any way to clear connection pool.because my site is hosted on shared hosting and they have provided limited connections. In my codding i have closed all the connection after use, but still i am getting warning for suspending database.</p>
  
  <p>Can any one tell me how to find number open connections on database and and how to clear connection pool.</p>
  
  <p>i used using statements for connections and closed all connections after used in finally block. so though there is error it closes oped connections. </p>
  
  <p>Thanks in advance.</p>