Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bhavesh.darji
Starting Member
11 Posts |
 Posted - 2011-08-23 : 01:38:54
|
| Hello Everyone,Can anyone tell me how to remove unused connection from the SQL Server 2008.I have seen the 'sp_who' SP but it gives the all the spid. From which i dont understand which is used or which not.Or is any other way to find out how many unused connection in the Server. And how can i remove that from SQL Server management studio?Bhavesh |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2011-08-23 : 01:50:48
|
| Basically you can use sp_who and see if a particular spid has host name associated with it. If not, probably the connection is idle or closed. You can remove such connections using KILL statement.However, you can only kill user connections with KILL command and not SQL Server processes which are also shown in sp_who output.Harsh Athalyehttp://www.letsgeek.net/ |
 |
|
|
bhavesh.darji
Starting Member
11 Posts |
Posted - 2011-08-23 : 02:23:47
|
| Thanks Harsh.I have run the sp_who as you said with a particular spid has not host name associated with it. But i does not find any such records. That means i have all the connection in used??If so then i have some other problem with my connection because number of rows in result of sp_who is increasing. Can you guide what to do to maintain that. Or any other suggestion for tuneup the database. You can provide me link also to read.Bhavesh |
|
|
|
|
|
|
Remove Unused Connection