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