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 2000 Forums
 SQL Server Administration (2000)
 Question about managing SQL processes

Author  Topic 

dcarva
Posting Yak Master

140 Posts

Posted - 2007-06-29 : 16:27:02
Hello,

I am looking at the SQL processes currently running on my SQL Server for a given database. It shows:

SPID, Status, Command, Last Batch
55 SLEEPING AWAITING COMMAND 6/21/2007

Does the last batch of 6/21 mean that a connection has remained open since 6/21 and nothing has run since then in that process?

Thanks!
Danny

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-06-29 : 17:19:27
Yes

CODO ERGO SUM
Go to Top of Page
   

- Advertisement -