SQL Questions & AnswersMonitoring DBAs, Replicating Sprocs, and More
This counter, however, also accounts for such activity as the sequential reading of memory-mapped files, whether cached or not. Therefore, you must understand the expected behavior of the processes on your server in order to interpret this counter. The typical red flag for a mapped file reading is the following combination of characteristics:
A You can either script this using the rs tool, or you can use the Report Manager by following these steps:
© 2008 Microsoft Corporation and CMP Media, LLC. All rights reserved; reproduction in part or in whole without permission is prohibited.