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.
Subscribe to our Newsletter!
If you like our blog posts make sure you subscribe to our newsletter . We will share all kinds of great stuff for FREE!Top Posts & Pages
- Rename Server Name for SQL Server Cluster
- Unplanned Availability Group Failover
- T-SQL Tuesday: What's Currently Running?
- SQL Server Performance Root Cause Analysis in 10 Minutes
- Finding Top Offenders From Cache
- Converting a vertical table to horizontal table
- Make SQL Server Queries Run Faster
- Get index fragmentation statistics
- Adding a VLDB database to an SQL Server Availability Group
- Calculating DTU in Azure SQL Database
Categories
Pingback: 12 Steps to Workload Tuning – Winter 2012 Performance Palooza! | JohnSterrett.com