August 22, 2005 at 6:28 pm
Hello!
I am puzzled by PF Usage numbers reported on our SQL server. It is SQL Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB of RAM. SQL Server is restricted to 10GB. There is only one page file 2046MB. When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how this number is calculated. According to help : It is 'The amount of paging file being used by the system.' Considering I have paging file 2GB big how come Task Manager shows 10.3 GB?
Thanks you in advance,
Igor
August 24, 2005 at 4:06 am
What you see as physical size of PF (2GB) is said to be committed bytes and the rest (10.3 - 2) GB are in memory only and is called as Reserved bytes.
A PF can partially reside in memory as well as in disk
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply