471,084 Members | 1,033 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,084 software developers and data experts.

Linguring SPIDS

SQL Server 2000

Just curious - was wondering why some SPIDS are left hanging out there
for up to several weeks. There are no errors or anything. It looks like
normal processing.

Thanks,

Craig

Jul 23 '05 #1
1 1196
(cs******@dwr.com) writes:
SQL Server 2000

Just curious - was wondering why some SPIDS are left hanging out there
for up to several weeks. There are no errors or anything. It looks like
normal processing.


Without seeing the output from sp_who2 or similar, it's difficult to
say much useful. But if they are spid < 50, they are system processes.

If they are > 50, they are user processes, and apparently the client
that opened this connections are still clinging to them. The hostname
and prog_name columns in master..sysprocesses may give some clues.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Frank Py | last post: by
12 posts views Thread by InProcess | last post: by
1 post views Thread by Robert_Couldry | last post: by
2 posts views Thread by Kevin Jackson | last post: by
reply views Thread by msnews.microsoft.com | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.