Time spent by the various sessions either consuming or waiting for CPU cycles. This reading is an aggregation of CPU Usage and CPU Wait, which are both taken directly from the operating system (rather than MSSQL wait states).
Number of seconds a page will stay in the buffer pool without references. Low values of this metric require the buffer pool to frequently flush the page to the physical disk, thereby possibly indicating a memory issue. Such an issue should be investigated to see if it results from lack of physical memory, inefficient queries and so on.
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité