SQL Questions & Answers Monitoring 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 high number of Pages/sec
- A normal (average, relative to the system being monitored) or high number of Available Bytes
- A normal or small number for Paging File: % Usage
A You can either script this using the rs tool, or you can use the Report Manager by following these steps:
- Go to the folder in Report Manager where you have the report and click the Show Details button in the upper right.
- Click the Edit icon next to the report you want to share, and then click the Security link on the left.
- In the Group or username field, enter the DOMAIN\groupname for the group you created and assigned the users to. (You can add users individually, but groups are easier to manage.)
- Put a check next to the Browser role and click OK. And now you’re all set.
- Get SQL Server 2005 Service Pack 1
- Try it out in SQL Server Virtual Labs
- Learn about Full-Text Search in SQL Server
- Build a small installation and hone your skills with SQL Server 2005 Express Edition
© 2008 Microsoft Corporation and CMP Media, LLC. All rights reserved; reproduction in part or in whole without permission is prohibited.