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 |
|
kenchee
Starting Member
49 Posts |
 Posted - 2008-05-18 : 23:09:41
|
| Hi, I've just setup an 2 node active/active sql cluster (my first). Both servers have exactly the same specification, 16GB of RAM each and SAN attached. My question is, how do I configure the min and max memory for each sql instance. I've read some where that I need to follow the 20-40-40 rule as, 20% for the OS, 40% for the active sql instance on the node and the other 40% is for the other sql instance if it fails over. Are there any other gotcha that I need to be aware of? Can someone share some light with me in regards to this? ThanksKen |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-05-18 : 23:50:46
|
| is this a 32bit system or 64bit? |
 |
|
|
kenchee
Starting Member
49 Posts |
Posted - 2008-05-18 : 23:55:04
|
| 32 bit, with boot.ini set with only /PAE no /3GB |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-05-19 : 01:16:18
|
quote:
Originally posted by kenchee
32 bit, with boot.ini set with only /PAE no /3GB
so, hopefully you are running enterprise edition of SQL Server. scratch that, this no longer matters with SQL 2005 as standard edition does not have the same memory limitations as it used to have with SQL 2000.Anyway, it is unfortunate that you set this server up as 32bit, since AWE memory is not optimal. a 64bit setup would be much more straightforward.basically, what you will need to do is turn off dynamic memory allocation since this doesn't work with AWE memory in SQL server. your idea of setting 20-40-40 is a good one, although you may need to adjust your 40-40 environment to match the databases hosted in each instance. You may actually want to run it 50-30 for example depending on the size of each DB.-ecMake sure you set AWE memory up properly in SQL Server. There are KB articles regarding the proper setup. just having /PAE set in boot.ini is not enough. |
|
|
|
kenchee
Starting Member
49 Posts |
Posted - 2008-05-19 : 22:12:28
|
| thanks |
|
|
|
|
|
|
|
|
RAM config for active/active sql cluster