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 how mu
- From: "Roger Abell [MVP]" <mvpNoSpam@xxxxxxx>
- Date: Wed, 29 Aug 2007 23:38:02 -0700
Assuming by PF you mean pagefile, how are you determining PF usage?
Pagefile size does not indicate PF usage and defaults to amount of ram.
Have you customized SQL Server's memory use? or is this one of the
free SQLs (msde/express)? SQL Server normally holds the majority
of real memory, yielding back to the OS what it needs.
Roger
"Daniel" <softwareengineer98037@xxxxxxxxx> wrote in message
news:uVDfqNQ6HHA.1484@xxxxxxxxxxxxxxxxxxxxxxx
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?
.
- Prev by Date: Re: Active Directory - need a list of all users, groups and permission
- Next by Date: Re: Actually a Question About Windows Server 2003
- Previous by thread: 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 m
- Next by thread: Re: Active Directory - need a list of all users, groups and permission
- Index(es):
Relevant Pages
|
|
