Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: