• 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…