"No Outage": Maximum Performance Under Heavy SQL Server Workload
活动详情
录播
记录日期:May. 18, 2021
24726
AWC-No_Outage_Maximum_Performance_Under_H
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.
扬声器
Pinal Dave, SQL Server Performance Tuning Expert - SQLAuthority.com