Re: SQL Page File
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Thu, 28 Jun 2007 09:43:28 -0400
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@xxxxxxxxxxxxxxxxx> wrote in message
news:1B96AAEA-E76C-4292-A6EF-5E1462227ADD@xxxxxxxxxxxxxxxx
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
.
- Follow-Ups:
- Re: SQL Page File
- From: Tibor Karaszi
- Re: SQL Page File
- Prev by Date: Re: Upgrade from SQL 2000 (MSDN) to SQL 2005 Standard
- Next by Date: Re: Attach database failed
- Previous by thread: Re: Upgrade from SQL 2000 (MSDN) to SQL 2005 Standard
- Next by thread: Re: SQL Page File
- Index(es):
Relevant Pages
|
