Quest Database Training Days 2022 are Back! Join free, interactive sessions led by Brent Ozar, Pinal Dave, Janis Griffin and Neil Buchwalter. Your favourite tech experts are back to host six new Database Training Days. You’ll get the opportunity to learn from Microsoft Certified Master Brent Ozar, Oracle ACE Janis Griffin, performance tuning expert Pinal Dave and data modelling expert Neil Buchwalter.
Here is the link to sign up for the FREE training.
Here are two sessions which I will be presenting two sessions:
Continuous SQL Server Performance Tuning for DevOps Environments
Once efficient, a query can get slow when the workload and data in the underlying table change. There are so many parameters for any query that can drastically impact how the query performs. It is vital for us to keep an eye on various parameters and make sure that our queries give us optimal performance when there are changes in the data and workload. In this session, we will focus on various server and database configurations that impact the performance of the changing DevOps environment. Developers and DBAs will receive knowledge and scripts, which they can use to immediately gain performance from their slow running queries.
SQL Server Performance Tuning to Optimize Cloud Costs
Every query has a cost and it is usually measured via three important resources: CPU, IO and memory. When we deploy queries that are not optimized for the cloud, they usually lead us to either upgrade the cloud subscription model with expensive resources or extremely slow performing queries. In this session, we will focus on how we can tune our queries so that when they are deployed to the cloud, they run extremely efficiently with limited resources. Developers and DBAs will receive knowledge and scripts, which they can use to immediately gain performance from their slow running queries.
Do not miss out on the sessions. The link for the registration is here.
Reference: Pinal Dave (http://blog.SQLAuthority.com)