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.
When & Where
Pittsburgh SQL Server User Group
The mission of the Pittsburgh SQL Server User Group is to provide an opportunity that will allow database developers, database administrators and all other IT professionals who work with databases to connect, share and learn for free. While everyone's shop might be unique the majority of the DBA's have similar projects and problems. We will allow all users the opportunity to share their experiences while they can also build their soft skills.