Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Areas chart displays the usage in megabytes of each type of cache in use.

MetricWhy it is important
DatabaseIndicates the amount of system memory (in MB) used by the database cache manager to hold commonly-used information from the database file(s) to prevent file operations.
FreeA low amount of free cache indicates a higher risk of performance issues.
Procedure CacheIndicates the amount of space used to store query plans.
OtherIndicates the amount of space used by other processes.

Anchor
-1981609489
-1981609489
Cache Hit Ratios gauge

...

Scroll pdf ignore
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >