My available memory is down to very little, yet my PF Usage is 8 gigabytes (about how much memory is on the box), sql server keeps having memory issue

[Guest Daniel]

My available memory is down to very little, yet my PF Usage is 8 gigabytes (about how much memory is on the box), sql server keeps having memory issues yet the sqlservr.exe is using hardly any memory.. how to fix this? is there some way to limit how

 

My available memory is down to very little, yet my PF Usage is 8 gigabytes

(about how much memory is on the box), sql server keeps having memory issues

yet the sqlservr.exe is using hardly any memory.. how to fix this? is there

some way to limit how much memory can be used by this PF Usage? why is PF

Usage using all my memory so that sql server cant use hardly any?

[Guest Newbie Coder]

Re: My available memory is down to very little, yet my PF Usage is 8 gigabytes (about how much memory is on the box), sql server keeps having memory issues yet the sqlservr.exe is using hardly any memory.. how to fix this? is there some way to limit

 

Re: My available memory is down to very little, yet my PF Usage is 8 gigabytes (about how much memory is on the box), sql server keeps having memory issues yet the sqlservr.exe is using hardly any memory.. how to fix this? is there some way to limit

 

Daniel,

 

Available memory:

 

Right-click MY COMPUTER | PROPERTIES

 

Look at the bottom of the GENERAL tab for installed memory

 

Have you set your page file to be so large?

 

Right-click MY COMPUTER | PROPERTIES | ADVANCED tab | PERFORMANCE OPTIONS

 

What is the size of your virtual memory? Microsoft recommend a minimum of

installed memory size + 12 MB

 

To clear the page file:

 

START | RUN | Type 'regedit' (without quotes) & press ENTER

 

Navigate to:

 

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory

Management

 

Create a new key in the right pane as follows:

 

Key Name: ClearPageFileAtShutdown

Key Type: DWORD

Value: 1 = clear at shutdown, 0 = leave without clearing

 

Close the registry editor & reboot

 

What service pack & what version of SQL are you running? Some versions have

memory leaks therefore you should make sure the latest service pack is installed

 

--

Newbie Coder

(It's just a name)

 

 

 

"Daniel" <softwareengineer98037@yahoo.com> wrote in message

news:u2nomNQ6HHA.1212@TK2MSFTNGP05.phx.gbl...

> My available memory is down to very little, yet my PF Usage is 8 gigabytes

> (about how much memory is on the box), sql server keeps having memory issues

> yet the sqlservr.exe is using hardly any memory.. how to fix this? is there

> some way to limit how much memory can be used by this PF Usage? why is PF

> Usage using all my memory so that sql server cant use hardly any?

>

>