Solved

SQL Current Activity of each proccess using a query

Posted on 2002-04-17
5
300 Views
Last Modified: 2008-02-26
Is there any way to know the current activity of each process in my SQL Server without use the current activity in the enterprise manager ?
Is there any undocumented table that can i query for know the issue ?
0
Comment
Question by:andresfbg
  • 2
5 Comments
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 100 total points
ID: 6948041
Master..sysprocesses contains info for active processes.
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 6948046
This is the primary table that sp_who and sp_who2 use to display activity.
0
 
LVL 5

Expert Comment

by:spcmnspff
ID: 6948054
Have you tried sp_who2 ?  It's not all the same info but about 80 percent of it is.  Run sp_Who2 from query analyzer and it will give you the process info of all the current processes on that server.
0
 

Expert Comment

by:CleanupPing
ID: 9280612
andresfbg:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
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…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

776 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