Speaker: Pinal Dave
A query once efficient can get slow when the workload as well as data in the underlying table changes. 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.