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 |
|
marileng
Starting Member
28 Posts |
 Posted - 2002-09-19 : 01:57:35
|
| If a status of SPID is 'sleeping' does it affect the server? Does it lessen the performance of the machine? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-19 : 05:06:58
|
| sleeping means that it is not doing anything.It will still have a slight effect as it takes up resources and the odd cycle now and then.Note that spids will be sleeping between actions so just because your snapshot shows this status doesn't mean it's necessarily inactive. Look at the last_batch and login_time.physical_io will show how much it has done.dbcc inputbuffer (spid) shows the last command.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SPID Status