For details, see Viewing the SQL Server I/O activity .
The Compiles flow displays the rate of SQL compilations and recompilations per second.
When many recompiles take place, the SQL Server’s CPU can become overloaded, thereby slowing down everything running on that computer. As a result, the Recompiles alarm is invoked. For details, see Recompiles Alarm .
The Call Rates chart, displayed in the SQL Instance Summary panel of the SQL Activity drilldown, details the use of compiles and re-compiles during the last 60 minutes. For details, see Monitoring the call rates .
The Memory Activity pane allows monitoring the SQL Server’s dynamic memory management and ensuring its proper handling of the buffer pool.
In addition, this section allows viewing the SQL Server processes Checkpoint and Lazy Writes.
For details, see Monitoring the SQL Server physical I/O activity .
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center