Stored Procs by Logical Writes

Stored-Procs-by-Logical-Writes.

 

This report lists the Stored Procedures showing those with the most logical writes first.   Use this report to track down some of the Stored Procedures with possibly the most performance impact.

 

Prior to version 2.4.2 of Database Health Monitor, the time numbers shown are in Microseconds. After 2.4.2 of Database Health monitor the times have been changed to seconds which makes much more sense.

 

Stored Procs By Logical Writes report is available for databases running on SQL Server 2008, SQL Server 2008R2, SQL Server 2012, but not on SQL Server 2005 or older.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

To prove you are not a robot: *