OS Memory and Paging Performance Counters

Troubleshooting a SQL Server with OS Memory and Paging Performance Counters

The two areas we need to look at are Memory and paging file:

Check the counters like

In Memory
Available Mb > 100MB
Pages Input/Sec < 10 Pages/Sec Just a reference counter used with Pages Input/Sec, %Usage, %Usage Peak.In Paging File
%Usage < 70% %Usage Peak < 70%

Leave a Reply

Your email address will not be published. Required fields are marked *