For the best web experience, please use IE11+, Chrome, Firefox, or Safari

"No Outage": Maximum Performance Under Heavy SQL Server Workload

No Outage": Maximum Performance Under Heavy SQL Server Workload
On Demand
  • Recorded Date:May 18, 2021
  • Event:On Demand
No Outage": Maximum Performance Under Heavy SQL Server Workload
An experienced DBA knows that everything works fine when things are under control. However, as soon as the workload increases or a spike in traffic arrives, any server starts showing signs of stress. It is a good idea to keep a check on the server configurations and settings so no matter how workloads change (concurrent threads, high CPU/IO, memory queries, parameter sniffing), the server always runs optimally. In this fast-paced, demo-oriented session we will see a few critical and the most important configuration settings, that once enabled instantly improve performance to SQL Server. Our goal is to have no outages under a heavy workload.

Speakers

Pinal Dave, SQL Server Performance Tuning Expert - SQLAuthority.com

Watch Your Free Webcast

Please wait...

triangle-down check
By downloading, you are registering to receive marketing email from us. To opt-out, follow steps described in our Privacy Policy.

reCAPTCHA protects this site. See Google's Privacy Policy and Terms of Use.