|
|
Posted by Erland Sommarskog on 06/28/05 00:49
(csomberg@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, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|