Posts Tagged ‘Page file’
Changing the page file location on Windows Server 2008
Part of SQL Server installation, I had to decide where to put the page file. It is always advisable to have the page file in a different location, ie disk, than the operating system. The page file should ideally be located on a fast drive to improve performance. The default size of the pagefile is around 1.5 times the amount of RAM available.
This is how I changed the page file location on Windows Server 2008:
Right Click on My Computer and click on Properties
Click on Advance tab > Performance Settings
Performance Options > Advanced > Change...
Select C drive and choose No Paging File
Select D drive and choose System Managed
I prefered to have Windows managing the size of it as I have plenty of memory and disk space.
