Find the Most Time Consuming Code in your SQL Server Database

added by mopen
7/29/2010 5:30:52 AM

8 Kicks, 182 Views

This post will demonstrate how to find T-SQL code (SQL Server 2005/2008) that takes the most time to execute. Note that a time consuming code may not necessarily be inefficient; it also depends on the volume of data being processed.