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

[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?

 

[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?
>
>