I look through the site looking for some help in solving a doubt related to paging file configuration and I find a couple of threads very helpful.
I reach this link http://support.microsoft.com/kb/889654
but I really need help interpreting the situation...
I have a sql 2008 onto a windows 2008 R2 server (both x64, of course), running in a virtual machine configured with 4 cpus and 16 GB ram.
In the article MS sayd that "as the amount of RAM increases, the need of a pagefile decreases".
16 GB ram is a big quantity for that kind of sql server (it contains 10 DB for a total of 500GB data, 100 users max) so I suppose that the page file shouldn't be very large (maybe even set to zero...) but I dig a bit using performance monitor and i found a strange behaviour.
extract from article:
Memory\\Available Bytes No less than 4 MB
Memory\\Pages Input/sec No more than 10 pages
Paging File\\% Usage No more than 70 percent
Paging File\\% Usage Peak No more than 70 percent
Process\\Page File Bytes Peak Not applicable
Memory\\Available Bytes 2GB (I configured sql to use 12GB)
Memory\\Pages Input/sec average 250!!! (max 700!!!)
Paging File\\% Usage 4%
Paging File\\% Usage Peak 5%
Process\\Page File Bytes Peak 16 GB (related to _total counter)
So, I really don't understand this behaviour: the percentage of page file used convinced me that I really don't need a big page file (surely not 1,5 times the amount of ram) but I don't understand the data related to pages input/sec.
Someone could help me???