Solved

SQL Current Activity of each proccess using a query

Posted on 2002-04-17
5
281 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:
ScottPletcher earned 100 total points
ID: 6948041
Master..sysprocesses contains info for active processes.
0
 
LVL 69

Expert Comment

by:ScottPletcher
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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 to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

708 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

11 Experts available now in Live!

Get 1:1 Help Now