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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Process Status Sleeping

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.
Go to Top of Page

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.....
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-28 : 22:13:05
Every sql connection uses memory.
Go to Top of Page
   

- Advertisement -