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…