Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

PF Usage Issue Expand / Collapse
Author
Message
Posted Thursday, March 26, 2009 3:12 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 29, 2010 2:48 AM
Points: 124, Visits: 275
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
Post #684628
Posted Friday, March 27, 2009 5:04 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:17 AM
Points: 1,398, Visits: 6,422
Task manager isn't reliable above 2gb. Try Process Explorer or performance counters.
What does PF stand for? (page faults?)
Post #685458
Posted Tuesday, May 12, 2009 8:05 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:02 PM
Points: 3,325, Visits: 6,737
PF = Page File.
Communication Link Failure is something to do with the Network issues.


-Roy
Post #715097
Posted Tuesday, May 19, 2009 1:21 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:54 AM
Points: 1,687, Visits: 452
Try to limit PF usage between 4gb as a min and 6GB as a max.

Set AWE enabled.




- Pradyothana


http://www.msqlserver.com
Post #720114
Posted Tuesday, May 19, 2009 1:37 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:02 PM
Points: 3,325, Visits: 6,737
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
Post #720128
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse