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 |
msakie
Starting Member
2 Posts |
Posted - 2007-09-27 : 08:33:15
|
Hi guys,I may be asking a foolish question but I really need an answer for it.. We have our centralized servere where SQL Server 2005 is installed.... Whenever open the management studio from our desktops, execute some queries (It may be any simple query such as select * from) I find the status of that process 'sleeping'...untill we close the studio or in other words untill that process is killed..I find the status by Management -> Activity monitor...Please help me with it... Has there been anything wrong while setting up Sql Server ?Please help me ...Thank you so much...Saket. |
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-27 : 08:47:55
|
This is normal behavior, the connection will stay open until it is closed. Future guru in the making. |
|
|
msakie
Starting Member
2 Posts |
Posted - 2007-09-28 : 04:28:21
|
Ok Thanks Zoroaster !I did not realize it that when we open the studio we open an instance of Sql Connection..Thanks .. I was thinking that It is adding an overhead to the SQL Server memory..... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 22:13:05
|
Every sql connection uses memory. |
|
|
|
|
|