How to bring Paging File usage metric to zero?
- by AngryHacker
I am trying to tune a SQL Server. Per Brent Ozar's Performance Tuning Video, he says the PerfMon's
Paging File:%Usage should be zero or ridiculously close to it. The average metric on my box is around 1.341%
The box has 18 GB of RAM, the SQL Server is off, the Commit Charge Total is 1GB and yet the PerfMon metric is not 0. The Performance of the Task Manager states that PF Usage is 1.23GB.
What should I do to better tune the box?