October 6, 2003 at 8:03 am
My SQL Server 2000 runs on a box partitioned into a c and d drive. The C drive is using up space faster than I though it would. There are 804 MB left.
The pagefile.sys is taking up most of the space. I don't quite understand why this is. Is there any way to reduce the size of the page file?
October 6, 2003 at 9:24 am
Cross,
The pagefile is necessary for normal windows operation. Personally, I think the pagefile should be set to use between 1 and 1.5 times the physical memory on the box... so if you have 1 GB of RAM, you should have your pagefile set to 1024 - 1536MB. Of course, this can be a max value if you don't think your server needs that large of a pagefile.
Have you considered moving the pagefile to the D:\ drive?
Sincerely,
Dan B
October 7, 2003 at 1:31 am
hi!
right-click on "my computer", select "properties", select "advanced" tab, click on "performance options". to change size and location of your pagefile(s) click on "Change ...".
be aware that on any changes you'll have to reboot your box.
best regards,
chris.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply