Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

Archive for February, 2013

Paging file for SQL server

Posted by Simon Cho on 02/27/2013

Please don’t put 1.5 time of Physical memory.

Less amount is better for SQL server if you have a x64 machine and enough physical memory.

http://support.microsoft.com/kb/889654/en-us

http://blogs.msdn.com/b/buckwoody/archive/2010/06/29/the-windows-page-file-and-sql-server.aspx

http://www.brentozar.com/archive/2009/11/christian-bolton-on-sql-server-memory/

http://blogs.technet.com/b/askperf/archive/2007/12/14/what-is-the-page-file-for-anyway.aspx

http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-1-before-the-install/

 

Advertisements

Posted in Common | Tagged: , | Leave a Comment »