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 |
|
sreehari
Starting Member
37 Posts |
 Posted - 2006-08-24 : 08:24:41
|
| Hi allWe have configured a new server with 8GB RAM, To gain the best performance, which memory setting should be set is it Fixed memory ? or Dynamic Memory? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-24 : 08:27:50
|
| I would vote for fixed.Peter LarssonHelsingborg, Sweden |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-24 : 10:18:05
|
| if you are runnig a 32bit environment then this will have to be a fixed amount of memory for SQL. If you are running 64bit environment then it can be dynamic.It also depends on the version and edition of SQL Server you are running. Standard edition SQL 2000 (for example) can only address 2GB RAM even if you have 8GB installed in the server.-ecEDIT:the 32bit info above assumes PAE mode enabled |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-08-24 : 12:08:12
|
| I vote fixed.I assume PAE has been enabled?Is there anything else running on the box?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-08-25 : 07:55:56
|
| What PAE stands for?Also, when you use Fixed Memeory for SQL? Obviously, you select upto the maximum? Correct? Also, do you tick the Reserve physical memory for SQL Server as well? If you do, What is minimum then? Thanks |
|
|
|
|
|
|
is it Fixed memory ? or Dynamic Memory?