You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

The Memory Paging metric counts the number of pages being swapped in and out of memory per second. The Memory view on the Resources tab allows you to track paging and other key memory statistics over a period of time.

Reasons why this metric has no value

SQL Diagnostic Manager is unable to collect the corresponding counter due to one of the following reasons:

  • It usually takes two refreshes to begin populating the Memory Paging metric, which occurs within a few seconds.
  • OS Metrics collection is disabled or not working properly. You must enable OS Metrics collection for SQLdm to collect hardware performance metrics.
  • Lightweight Pooling is enabled. SQL Diagnostic Manager cannot collect OS metrics if Lightweight Pooling is enabled on the SQL Server instance.
  • The counter does not exist on this SQL Server instance.

 

SQL  Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
  • No labels