I am new to SQL 2005 so please bear with me. I have been told the SQL server
page file is best located on it's own RAID 1 partition or on the log file
partition. I was under the impression that SQL uses the system page file.
Can someone tell me if SQL does have it's own page file? If so, what the
name of this file is and how do I move it?
Thanks

SQL Server does not have it's own page file and tries its best to avoid
getting into a situation where anything needs to use the page file. If you
have enough memory and things are configured properly you should not have
paging issues unless you have other apps running on the same server that
misbehave.

--
Andrew J. Kelly SQL MVP

"Dan" <dmueller@netspheretech.com> wrote in message
news:1B96AAEA-E76C-4292-A6EF-5E1462227ADD@microsoft.com...
>I am new to SQL 2005 so please bear with me. I have been told the SQL
>server
> page file is best located on it's own RAID 1 partition or on the log file
> partition. I was under the impression that SQL uses the system page file.
> Can someone tell me if SQL does have it's own page file? If so, what the
> name of this file is and how do I move it?
> Thanks

In article <1B96AAEA-E76C-4292-A6EF-5E1462227ADD@microsoft.com>,
dmueller@netspheretech.com says...
> I am new to SQL 2005 so please bear with me. I have been told the SQL server
> page file is best located on it's own RAID 1 partition or on the log file
> partition. I was under the impression that SQL uses the system page file.
> Can someone tell me if SQL does have it's own page file? If so, what the
> name of this file is and how do I move it?
> Thanks
>
I suspect that this is referring to the best practice recommendation to
separate the OS page file and operating files from each other and from
SQL. If that needs to be compromised, it is better (perhaps) to put the
page file on the logfile drive than on the program drive. And anyway if
you are doing much paging you've got some serious other issues to look
at.
--
Graham (Pete) Berry
PeteBerry@Caltech.edu

Perhaps Dan was referring to tempdb?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:OzvgTpYuHHA.4612@TK2MSFTNGP04.phx.gbl...
> SQL Server does not have it's own page file and tries its best to avoid getting into a situation
> where anything needs to use the page file. If you have enough memory and things are configured
> properly you should not have paging issues unless you have other apps running on the same server
> that misbehave.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Dan" <dmueller@netspheretech.com> wrote in message
> news:1B96AAEA-E76C-4292-A6EF-5E1462227ADD@microsoft.com...
>>I am new to SQL 2005 so please bear with me. I have been told the SQL server
>> page file is best located on it's own RAID 1 partition or on the log file
>> partition. I was under the impression that SQL uses the system page file.
>> Can someone tell me if SQL does have it's own page file? If so, what the
>> name of this file is and how do I move it?
>> Thanks
>
>