August 22, 2007 at 7:54 am
Hi,
setting up a new SQL Server 2005 box, it's 64 bit and will have 32Gb of RAM. I was wondering what size the page file should be?
1.5 x 32Gb is a lot of hard disk space to use just for the OS, and as far as I am aware SQL Server won't use more than a few hundred meg of that and will instead concentrate on using the RAM.
Any input on this is much appreciated.
August 22, 2007 at 11:57 am
Please clarify what do you mean page file ? Page size is fixed 8k size, data file size depends on your volume of data. And again, it's not clear you will have 32 GB of RAM or hard disk space ?
August 22, 2007 at 12:48 pm
Sorry if that wasn't clear.
I'm referring to virtual memory.
August 22, 2007 at 12:56 pm
Look at MS suggestion on how to determine what you need.
August 23, 2007 at 3:52 am
Thanks very much, this seems to be exactly what I was looking for (but couldn't find). Very much appreciated, to everyone, for helping.
August 23, 2007 at 7:31 am
what you need to remember is that sql server should not use the page file - therefore on a dedicated box you should set the page file to a fixed size and forget it ( near enough ) for small amounts of memory it doesn't matter too much but if you have 128gb of ram and the page file is suggested as being 256gb, that's plainly rather large! For a dedicated box probably 4Gb would be the size to go for. Fixed size too - no dynamic stuff.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply