Finding Your Top 10 SQL Server Queries

Thursday Nov 6th 2008 by DatabaseJournal.com Staff

Take a little effort to identify your worst-performing queries.

[From SQL Server Magazine]

If you need to parse Microsoft SQL Server server-side trace information so that you can aggregate the data to find your worst-performing and most-called queries, you might try turning to the T-SQL user-defined function called SQL_Signature.

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=100121

Mobile Site | Full Site