Home / server / Questions / 317404
Accepted
Darian Miller
Asked: 2011-10-01 15:06:14 +0800 CST

SQL Server 2008 R2 - RAM = 128GB, PageFile = 192GB?

  • 772

Is there a definitive guide for PageFile size on the latest 64-bit servers with large amounts of RAM?

I've seen conflicting recommendations, and am wondering if the latest releases have changed the recommendations.

pagefile sql-server-2008-r2

1 Answers

  1. Best Answer

    When running SQL Server on a box with a lot of RAM set the page file to about 6 Gigs. SQL Server won't swap to disk unless something really wrong happens and allocating 192 gigs of disk space to a page file that will never be used is insane.

    • 2