March 26, 2009 at 3:12 pm
Hello experts..
Though am not sure if this is the right forum for my issue, still posting..
I have an issue with my Production SQL server box. I have windows 2003 server on which SQL server 2000 is installed.
The box having 8 GB RAM.
From past few days, it has been observed that, PF usage is occupying 6.7 GB where as when i checked under processes tab in Task manager, the total amount of Mem usage is not exceeding 2 GB. but in Task manager, under Performance tab, PF usage is showing 6.7 GB used.
Where is rest memory gone...?
When i checked even viewer, am seeing some errors with event id 17052 Error "Communication link failure" ....does it cause any mem issues?
Please help me in fixing this issue.
--Raj
March 27, 2009 at 5:04 pm
Task manager isn't reliable above 2gb. Try Process Explorer or performance counters.
What does PF stand for? (page faults?)
May 12, 2009 at 8:05 am
PF = Page File.
Communication Link Failure is something to do with the Network issues.
-Roy
May 19, 2009 at 1:21 pm
Try to limit PF usage between 4gb as a min and 6GB as a max.
Set AWE enabled.
May 19, 2009 at 1:37 pm
pradyothana (5/19/2009)
Try to limit PF usage between 4gb as a min and 6GB as a max.Set AWE enabled.
Why do you want to limit the PF page between 4 GB and 6 GB? As rule of thump when setting Page file , it should be one and half times as big as the Physical memory. Only thing they say when setting for SQL Server is to make it as one single figure and not set a min and max.
-Roy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply