Anyone knows what the size should the Paging File be for a 8 P 16 Core Opteron server with 128GB memory installed? The server will be running SQL 05 Ent and IIS, on top of Win2k3 R2 x64 Ent.
Please also give the reason for that size.
Regards,
dong
On a SQL Server you want the page file size to be as small as possible so that SQL Server will be using real memory instead of slower virtual memory. SQL Servers are resource-rich centralized beasts. That's one of the reasons they are faster than a desktop database or btrieve library. The optimal size would be 0 but you need a pagefile big enough to hold any memory dumps your server might create. If you can handle just getting mini-dumps which are just 64K, you could set your pagefile very very small. Otherwise, you need a pagefile at least the same size as your memory size, which sucks. Its been back to SQL 4.2 since I actually used a memory dump, so I generally turn them off. You can always turn them back on if your machine starts acting screwey.
No comments:
Post a Comment