Introduction to Performance Tuning with SQL Server 2012
Friday, September 13, 2013 from 9:00 AM to 4:00 PM (EDT)
Have you always wanted to dig into performance tuning but wasn't sure where to start? During this pre-con you will be able to find out which SQL statements are causing your performance problems and you will be able to apply basic concepts to improve your general performance. You will learn how to implement and use a performance baseline to be proactive and keep yourself one step ahead of the game. We will cover bad developer practices that are constantly being repeated and show you how to fix them. We will also show you how to improve the performance of your troublesome queries when you cannot change the code. Finally, we will also cover best practices that can be applied to help performance on the database and instance settings level.
John Sterrett is a database admin senior advisor for Dell, directly responsible for several mission-critical databases. Previously, he was a senior DBA focused primarily on performance tuning at a Remote DBA service company with over 200 SQL Server clients. He has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturday, and local PASS Chapter and Virtual Chapter meetings. He is a PASS Regional Mentor for the South Central US region, co-founded the West Virginia SQL Server User Group, and hosted the first and second SQLSaturday in West Virginia. He is a syndicated blogger at SQLServerPedia and SQLServerCentral.com and you can find his blog at http://johnsterrett.com
1. Find root cause to slow performance
2. Understand how to apply correct indexes to improve performance without modifying any code.
3. Identify bad T-SQL coding practices and be able to fix them
4. Implement general best practices to improve performance
OTHER COURSE INFORMATION:
Course Hardware and Software Requirements:
Included with the seminar are a collection of tuning and monitoring scripts and a copy of all presentations.
Food: Lunch will be provided at the event location. Please contact the organizer is you require a vegetarian option.
Cancellation policy: no cancellations/refunds/exchanges allowed except if event is cancelled for any reason. Full payment of $120 is due at the time of registration.