Which of Your Stored Procedures are Using the Most Resources?

Posted on SQL Server Central See other posts from SQL Server Central
Published on Mon, 31 Jan 2011 07:00:00 UT Indexed on 2011/02/01 7:30 UTC
Read the original article Hit count: 288

Filed under:
Dynamic Management Views and Functions aren't always easy to understand. However, they are the easiest way of finding out which of your stored procedures are using up the most resources. Greg takes the time to explain how and why these DMVs and DMFs get their information. Suddenly, it all gets clearer.
SQL Backup Join SQL Backup’s 35,000+ customers
to compress and strengthen your backups

"SQL Backup will be a REAL boost to any
DBA lucky enough to use it." Jonathan Allen.
Download a free trial now.

© SQL Server Central or respective owner