September 18, 2002 at 11:54 pm
If a status of SPID is sleeping does it affect the server? Does it still the performance of the machine?
September 19, 2002 at 1:35 am
More-or-less no. It does use a little bit of memory (each connection uses 12 KB + (3 * Network Packet Size), default network packet size is 4KB), but you probably don't need to worry about that.
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
September 20, 2002 at 12:08 am
Even spid is showing status as sleeping sometimes it does working internally.
To verift check the master..sysprocesses table for that spid and the value for waitinresource column, is always changing
Prakash
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply