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 |
|
imarchenko
Yak Posting Veteran
57 Posts |
 Posted - 2009-11-18 : 20:05:47
|
| Hello! We will be installing SQL Server 2008 64 bit EE on Windows 2008 EE (Active/Active cluster). I would like to confirm following settings considering we will have 32GB of memory on each node:1. No need to enable AWE.2. No need to set 'Lock Pages In Memory'.3. Cap Min and Max Memory usage on each instance (leave memory not only to OS, but also to the second instance in case of failover). I am not exactly sure how to cap memory. Would it be possible to make memory Max adjustment when failover occurs? Otherwise, we might be wasting memory. 4. No need to set /3GB in boot.ini.Any other configurational setting to consider?Thank you in advance,Igor |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-11-18 : 21:03:18
|
| You do need to set "lock pages in memory" according to what I heard from a MS engineer. I don't have supporting documentation on that, so you might want to look it up in case the MS engineer is incorrect.Give 2-4GB of memory to the OS and other processes by capping the maximum. Yes you can make memory adjustments when the failover occurs. This would make better use of the memory on each node so that each instance can consume more.In the case of a failover, just let the instances fight for memory initially until you are able to get in there and cap each down. Here's an example:Server1 - 32GBInstance1 - 28GBServer2 - 32GBInstance2 - 28GBFailover, loss of Server2:Instance1: 18GBInstance2: 10GBThe rest is correct in your post.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
imarchenko
Yak Posting Veteran
57 Posts |
Posted - 2009-11-19 : 13:38:48
|
| Thanks a lot, tkizer! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-19 : 14:52:38
|
quote:
Originally posted by tkizer
You do need to set "lock pages in memory" according to what I heard from a MS engineer. I don't have supporting documentation on that, so you might want to look it up
That's correct. http://blogs.msdn.com/slavao/archive/2005/04/29/413425.aspxAlso, while BOL states that AWE is not available on 64x servers, in fact it is and can be useful as well. |
|
|
|
support.sql
Starting Member
15 Posts |
Posted - 2009-11-26 : 22:35:53
|
| HiYou can use @nalytics Performance Data Collector for Microsoft SQL Server & Windows Server,this tool can help you to solve your performance problems, I have tested it works excellent and it is very easy to configure and implement it.VisitRegardsSQL Gurusupport.sql@gmail.comSQL Guru |
|
|
|
|
|
|
|
|
SQL Server 2008 cluster memory conf.