Database Training Days 101: Continuous SQL Server Performance Tuning for DevOps Environments with Pi

A query that was once efficient can slow down significantly as the workload and data in the underlying table change. With numerous parameters impacting query performance, it’s crucial to monitor and adjust configurations to ensure optimal performance as data and workloads evolve. In this session, we will explore various server and database configurations that influence performance in a changing DevOps environment. Developers and DBAs will gain valuable knowledge and scripts to immediately improve the performance of their slow-running queries.

Topics that will be discussed include:

• Monitoring and adjusting query parameters for optimal performance
• Understanding the impact of data and workload changes on query efficiency
• Server and database configurations critical to performance in DevOps
• Practical scripts and strategies to enhance query performance

Speaker:

• Pinal Dave, SQL Server Performance Tuning Expert at SQLAuthority.com