SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


PF Usage Issue


PF Usage Issue

Author
Message
Jus
Jus
Mr or Mrs. 500
Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)

Group: General Forum Members
Points: 508 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
Jo Pattyn
Jo Pattyn
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 6985 Visits: 10009
Task manager isn't reliable above 2gb. Try Process Explorer or performance counters.
What does PF stand for? (page faults?)
Roy Ernest
Roy Ernest
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8443 Visits: 6891
PF = Page File.
Communication Link Failure is something to do with the Network issues.

-Roy
Pradyothana Shastry
Pradyothana Shastry
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2229 Visits: 507
Try to limit PF usage between 4gb as a min and 6GB as a max.

Set AWE enabled.


- Pradyothana


http://www.msqlserver.com
Roy Ernest
Roy Ernest
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8443 Visits: 6891
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search