May 16, 2011 at 9:57 am
Hi Folks
I am starting to configure a new Windows 2008 R2 64-bit Server with 8GB of RAM to run SQL Server 2008 R2
I have read several articles and visited several forums and there is no concensus it seems on what the pagefile should be and now I am totally confused.
If anyone has been down this alley, I would appreciate it
Advise has been:
SQL Server does not use pagfile if it is dedicated, it uses TEMPDB so you do not need one
On Windows 2008 and 2008R2 PageFile should equal RAM
You only need 2GB
If your system crashes you need RAM+1MB
If your system crashes you need RAM+300MB
May 16, 2011 at 10:01 am
duplicate post. Please provide all responses here
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 16, 2011 at 10:02 am
Yes
sorry about that
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply