Solved

sp_who2 result

Posted on 2006-10-30
2
2,078 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
ID: 17839628
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
ID: 17839675


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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

861 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