Tag: trace

Finding the “heaviest” TSQL to Optimize in SQL Server

Brett Hawton – 27 September 2010 There have been many articles written about methods to try to identify the worst performing TSQL statements on a SQL Server in order to optimize those statements for improved execution speed. Typically, the time-honored method is to either run a continuous trace or harvest the DMV information at frequent [...]