Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
carloarango
Starting Member
15 Posts |
 Posted - 2007-12-26 : 10:06:23
|
| I have gotten mixed comments on this topic. I have a 64 bit machine running 64 windows 2003 standard and 64 SQL 2005 standard with 8 GB of RAM. We want to upgrade it to 32 GB. What is the best approach to do this? Dynamic or Stattic giving min and max server memory a value ? and if static what value should I use for 32 GB knowing that this box is only being used for SQL. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-26 : 10:11:51
|
| use dynamic. let sql server handle how much memory it needs by itself._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-26 : 10:53:16
|
| If you have multiple instances and especially if it's a cluster, then you should use static.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-26 : 22:35:19
|
| Either case you have to set max memory, leave 2gb for os. |
|
|
|
|
|
|
What is better.. Static or dynamic memory allocati