|
|
|||
Home | Troubleshooting | Quick Setup | Cisco How to | Data Recovery | Forums | Blog | IT Exam Practice | Services | About Us | Chicagotech MVP | Search | Contact Us | |
|
How to Monitor Memory Usage in Microsoft SQL server
Note: The Available Bytes counter indicates how many bytes of memory are currently available for use by processes. The Pages/sec counter indicates the number of pages that either were retrieved from disk due to hard page faults or written to disk to free space in the working set due to page faults. Low values for the Available Bytes counter can indicate that there is an overall shortage of memory on the computer or that an application is not releasing memory. A high rate for the Pages/sec counter could indicate excessive paging. Monitor the Memory:
Page Faults/sec counter to make sure that the disk activity is not caused by
paging.
Note: By default, SQL Server changes its memory requirements dynamically.
Whenever SQL Server needs more memory, it takes available physical memory.
If SQL Server does not need the memory currently allocated to it, it
releases the memory to the operating system. You may adjust how many the
memory SQL will use by enable AWE. To monitor above accounts, run perfmon and add those accounts as shown.
Post your questions, comments, feedbacks and suggestions Related Topics
|
|
|
This web is provided "AS IS" with no warranties.
Copyright © 2002-2018
ChicagoTech.net,
All rights reserved. Unauthorized reproduction forbidden.