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 |
|
uri dimant
Starting Member
16 Posts |
 Posted - 2002-05-13 : 00:40:14
|
| Hello.we are using sql7 and nt4.0my question is if an user is in "sleeping" status does cpu take system resourse ? after select cpu,status from sysprocesses i got below outputcpu status12554 sleepingby dbcc inputbuffer i see that a last query of this spid was simple select * from table .(in vb app i have rs.close and set rs=nothing)can someone give me explain what is wrong and why cpu of this spid still stay highthank you. |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-05-13 : 09:37:02
|
| The value of CPU activity shown in sysprocesses table is cumulative, meaning it displays the CPU time used since this spid was first created (i.e. since database connection was made)... If you watch the value carefully, you'll see that it does not increase as long as the spid is sleeping (no new commands are issued on that connection). |
 |
|
|
|
|
|
CPU Question