By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,963 Members | 1,863 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,963 IT Pros & Developers. It's quick & easy.

EnterpriseManager-->Process Info Screen

P: n/a
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

Oct 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
(cs******@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, es****@sommarskog.se

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

Oct 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.