This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Reports for Long running process, blocking/locking and other parameters...

I'm looking to create some daily run reports to show the previous 24 hour stats with the following parameters:

  • Long running process (can a timefame be attached at set up?  If so, how?)
  • Stored Procs that are being memory resource hogs.
  • Bad execution plans
  • Locks/blocks

 I'm also looking at adding a custom dashboard with just these 4 graphs in there.  Is this possible?

Thank you!

 

John