Tuning the performance of your queries in SQL Server can be a lot of work. However, in order for your systems to receive the full benefits of query tuning, you must tune the queries that need it the most. This session will show you three different methods for determining which of the queries on your system are being called the most frequently, take the longest period of time to run, or are using the most resources. You’ll be able to use the information in this session to quickly set up your own metrics gathering processes in order to understand what is happening on your systems and which queries will benefit most from tuning.
Grant Fritchey, Product Evangelist Redgate Software
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.