1
one of common problems in Sql serverl is pool over because of open connections are not closed.
sp_who2 will help you to see open connections to your SQL database engine.
this is screenshot of the result of the run
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7nbHY3KPfl0hWt9BgFwZCr17wln8sBL-323CTb9EgmA1olmIsfYpS9HDSGv268XxRTq0pYuAn8UByOMMot6ykLucYMd7bClNvPfI1Mr8qz17AKFwrzDmFwznsz4rE5Vy_uKfQu1HRM42b/s400/sql.PNG)
SELECT @@MAX_CONNECTIONS AS 'Max Allowed Connections'
Posted on 8:21 AM by Softminer and filed under
SQL
one of common problems in Sql serverl is pool over because of open connections are not closed.
sp_who2 will help you to see open connections to your SQL database engine.
this is screenshot of the result of the run
SELECT @@MAX_CONNECTIONS AS 'Max Allowed Connections'
to have select query on sp_who to see the connection of specific database
|
Nice Thanks
Computech
Post a Comment