Posted by Erland Sommarskog on 10/22/05 00:37

(csomberg@dwr.com) writes:
> SQL 2000 SP3
>================================================
>
> In reviewing this screen, I have SPIDS > 100 that have a status of
> sleeping, command = AWAITING COMMAND and login/batch dates that are
> weeks old ... Shouldn't this list be more recent activity only ?

I guess that depends on what you expect on your site. If you have
developers who connect through Query Analyzer every once in a fortnight,
this is would display like this.

I don't know if that screen shows application, hostname and that, but
you can use sp_who2 or query sysprocesses directly to get this information.
This can give you an idea whether this is normal, or if something is
fishy.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]