San Francisco, California
London, United Kingdom
Query Performance Tuning in SQL Server -
Query Performance Tuning in SQL Server
Sometimes, just buying bigger and better hardware isn’t possible and you still have problems with database performance you have to deal with. Now what do you do? Since about 80% of the time, the problem lies in the T-SQL code, you could try tuning your queries. This all day session takes you through everything you need in order to tune your queries. We’ll start with establishing an understanding of how the optimizer works, move through methods for capturing query performance metrics and then step through methods of fixing common problems. We’ll take advantage of the tools offered by Microsoft such as the Dynamic Management Objects, Query Execution Plans and Extended Events. You’ll leave with a better understanding of how to identify and fix poorly performing queries that you can apply immediately on your own systems.
When & Where
North Texas SQL Server User Group
The North Texas SQL Server Users Group was formed to provide a forum where Microsoft SQL Server database administrators and developers could meet to learn more about the product, share ideas and make contact with other similar individuals. It is our goal to provide new concepts and detailed information on the product which will enable the users of SQL Server to see it function to its fullest potential.