Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have been tasked to see whether SCOM 2012 is the right tool to do the following, which have been asked of me:

  • Find out what are the longest running queries
  • Find out the number of locks

Does anyone have any advice, or can anyone point me to a comprehensive guide in trying to get SCOM to monitor the above?

share|improve this question
up vote 1 down vote accepted

SCOM is extended using management packs. The Microsoft SQL Server management pack is documented here.

If you look at the Appendix - Reports section you'll see that out-of-the-box reports include SQL Server Lock Analysis and Top 5 Deadlocked Databases.

The management pack does alert on long running SQL Agent jobs, but it does not monitor or report on long running queries. For that, you may need to look at some more SQL-specific analysis tools or use SQL scripts (such as this one: Find the TOP n Longest Running Procedures (or Queries), Ordered by Total Impact on Server)

share|improve this answer

You can also get quite extensive information on what each management pack contains by visiting MPWiki. The SQL management pack is detailed here.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.