Monday, March 16, 2009

Find slow performing T-SQL in no time

A lot of times when building applications against SQL Server everything works fine in the beginning, but over time performance starts to creep and things aren’t performing as good as they once used to when the application was originally released. The other day I ran across an article on the Database Journal website that I thought was worth sharing. Greg Larsen explains the powerful use of Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs) to help monitor an application's T-SQL performance. He also provides a Stored Procedure that makes use of DMVs and DMFs to produce a report that quickly identifies poorly performing T-SQL statements.