Improve company productivity with a Business Account.Sign Up

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

SQL Current Activity of each proccess using a query

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
andresfbg
Asked:
andresfbg
  • 2
1 Solution
 
Scott PletcherSenior DBACommented:
Master..sysprocesses contains info for active processes.
0
 
Scott PletcherSenior DBACommented:
This is the primary table that sp_who and sp_who2 use to display activity.
0
 
spcmnspffCommented:
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
 
CleanupPingCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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