EnterpriseManager-->Process Info Screen

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 ?

Thanks,

Craig(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/techin.../2000/books.asp