Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2127
  • Last Modified:

sp_who2 result

Hi,
I run sp_who2 and several spid found with sleeping status since 10 hrs ago, is this process is still  running in sql? and in command column what its mean by conditional?
0
motioneye
Asked:
motioneye
1 Solution
 
AaronAbendCommented:
a sleeping process is one that is still connected but it is not running anything.  Conditional means T-SQL if-then-else or similar logic was the last command run in that process.
0
 
Gautham JanardhanCommented:


Check if there are any spid with -2 value

In SQL Server 2000, all orphaned DTC transactions are assigned the SPID value of '-2'. Orphaned DTC transactions are distributed transactions that are not associated with any SPID. Thus, when an orphaned transaction is blocking another process, this orphaned distributed transaction can be identified by its distinctive '-2' SPID value.

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now