Active Monitor Connection status

hi all,

When does a SPID status change to 'Sleeping' and what does that indicate? I'm assuming that after so many seconds or minutes have passed with no activity, it changes the status to Sleeping - is that correct? What is the length of time?


And what does 'Suspended' mean?
Thanks,
Thulasi.

Check this link for status info http://msdn.microsoft.com/en-us/library/ms178520(SQL.90).aspx. May be these connections are used by connection pooling.

hi Madhu,
Thanks for your quick reply the url provided by you is very useful..
Actually in my Server there are lot of connections in sleeping mode, i understood that the sleeping connections will wait to perform some thing.
if we kill those process that will lose the connection pool.to establish connection pooling again it will take time.
Is there any way to kill all the sleeping connections after being idle for 2 mins.
Thanks,
Thulasi.