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%