Windows 2003 pagefile and SQL Server

[Chiefcrowe]

I want to move my pagefile from C: to D: on this SQL machine to save space. It is one Hard drive with these partitions.

I am thinking about setting the C: pagefile to 0 and then set D: to system managed.


Does anyone know if this would harm anything?

 

[bsobel]

You wont be able to save a crash dump unless the pagefile is on the boot drive, other than that you should be fine.

 

[Chiefcrowe]

thanks for the fast reply!

What if i put a small one , let's say 500 mb on C: and then have one on D: ?

 

[bsobel]

You can create a minidump with just 2MB on the boot drive, so you could set it to something like 8mb just to be safe and the rest moved. A full dump requires the same size pagefile as physical memory plus a few meg. So if its a 1gig system, you'd need 1gig plus about 2meg.

 

[Chiefcrowe]

excellent, thank you very much!

 

[Chiefcrowe]

one other question - if they are 2 separate hard drives can I still do the same thing?

 

[bsobel]

Originally posted by: Chiefcrowe
one other question - if they are 2 separate hard drives can I still do the same thing?

Yep.