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?