Open source stored proc by Adam Machanic
- Captures what is occurring now on the server
- Can be setup to capture output to table for later troubleshooting
- Link for documentation: http://sqlblog.com/blogs/adam_machanic/archive/2011/04/25/capt uring-the-output-a-month-of-activity-monitoring-part-25-of-30.aspx
Database Blog 