Pagefile for SQL Server

How important it is to work or configure pagefile for SQL Server ? We have
never bothered to look into it, but was just wondering if there are any
performance enhancements one could make by working on pagefile settings?Hi Hassan
For a server dedicated to SQL Server you should not see a great deal of
paging to the page file, but that does not mean that you should not still
follow best practices such as putting the page file on it's own dedicated
fast disc or making it large enough to hold the memory dump.
John
"Hassan" wrote:
> How important it is to work or configure pagefile for SQL Server ? We have
> never bothered to look into it, but was just wondering if there are any
> performance enhancements one could make by working on pagefile settings?
>
>|||> best practices such as putting the page file on it's own dedicated
> fast disc
I'm not sure this is really best practice from a practical viewpoint. I
wonder how many people do this. That's not the practice I have encountered.
Pagefiles are typically put on the system drives (customarily C and D in most
cases), which are typical a two-disk mirrored set.
Linchi
"John Bell" wrote:
> Hi Hassan
> For a server dedicated to SQL Server you should not see a great deal of
> paging to the page file, but that does not mean that you should not still
> follow best practices such as putting the page file on it's own dedicated
> fast disc or making it large enough to hold the memory dump.
> John
> "Hassan" wrote:
> > How important it is to work or configure pagefile for SQL Server ? We have
> > never bothered to look into it, but was just wondering if there are any
> > performance enhancements one could make by working on pagefile settings?
> >
> >
> >|||Hi Linchi
In my experience it does tend to be the first compromise, but that may be
because it isn't even considered!
John
"Linchi Shea" wrote:
> > best practices such as putting the page file on it's own dedicated
> > fast disc
> I'm not sure this is really best practice from a practical viewpoint. I
> wonder how many people do this. That's not the practice I have encountered.
> Pagefiles are typically put on the system drives (customarily C and D in most
> cases), which are typical a two-disk mirrored set.
> Linchi
> "John Bell" wrote:
> > Hi Hassan
> >
> > For a server dedicated to SQL Server you should not see a great deal of
> > paging to the page file, but that does not mean that you should not still
> > follow best practices such as putting the page file on it's own dedicated
> > fast disc or making it large enough to hold the memory dump.
> >
> > John
> >
> > "Hassan" wrote:
> >
> > > How important it is to work or configure pagefile for SQL Server ? We have
> > > never bothered to look into it, but was just wondering if there are any
> > > performance enhancements one could make by working on pagefile settings?
> > >
> > >
> > >