12 Steps to Workload Tuning
We might know how to tune a query for optimal performance or create additional indexes to ensure faster execution, but how do we ensure that our changes don’t hurt our total workload? Do we know if the new 3rd Party application upgrade will make performance better or worse? Do we know if your application can scale due to unexpected stress? In this session, we will go over a process used to tune a workload and answer the common questions above. In this presentation we will also use RML Utilities to answer these questions and even give you a little insight into how you can document these changes to help you get that next raise.
John Sterrett is a Group Principal and Sr. Consultant at Linchpin People. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Member Summit, SQLRally, 24 Hours of PASS, SQL Saturday’s, PASS Chapters and Virtual Chapter meetings. John is a PASS Regional Mentor and one of the founders of the WVPASS user group and the PASS HA/DR Virtual Chapter.
The meeting starts at 5:30PM CST with food and a QA session. The main presentation is at 6:00PM.
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759
Phone: (512) 795-5300
We meet the third Wednesday of each month. The meeting starts at 6:00 PM with food, and a QA session and the main presentation starts at 6:30 PM
Pleasant Hill Public Library
211 E. William Cannon Drive
Austin, TX, 78745
William Cannon just West of IH-35 /Free parking.
Follow @CACTUSS_SQL for the latest information.
Upcoming Speakers: http://cactuss.org/pages/speaker-calendar