Solved

sp_who2 result

Posted on 2006-10-30
2
2,058 Views
Last Modified: 2012-08-14
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
Comment
Question by:motioneye
2 Comments
 
LVL 10

Accepted Solution

by:
AaronAbend earned 250 total points
Comment Utility
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
 
LVL 29

Expert Comment

by:Gautham Janardhan
Comment Utility


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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now