I have a quick question. I have a server with the following specs:
Windows 2008 R2 Server 4GB RAM 2x CPU
SQL 2008 installed
If i create a 2nd disk on a server and size it to be 6.5GB, then move the page file to point to this newly created drive, this should be enough space right? Especially if i have specified in Page File settings to point to the new drive and make the minimum size 6.5GB.
There should be no reason that a page file would grow to larger than 6GB, since this is 1.5 times larger than the amount of RAM? Is this correct?
The reason i ask is that we recently did this on our DB server and the next day the server was complaining about not enough space for Page File.
Your help is appreciated