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.
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