September 9, 2011 at 9:38 am
Hiya
I want to set SQL memory on a client's cluster (capping it at 4gb).
Do I have to set this on each node? or does this setting (or any other) carry between the nodes?
I'm (maybe naively) presuming that because the system databases switch between nodes, so do the settings?
thanks
s
September 9, 2011 at 1:02 pm
Yes, that's right. database server level settings need be set at the instance level and persist regardless of the node. So, if you set the max memory paramter to 4GB through sp_configure, this setting persists across all nodes of the cluster.
These are database instance level settings. So, if there are mutiple database instances on this cluster, than you need to configure maximums for each instances, but not for each node.
September 10, 2011 at 5:22 pm
sqlbanana (9/9/2011)
I'm (maybe naively) presuming that because the system databases switch between nodes, so do the settings?
System databases (just as user databases) reside on the shared storage. There is a single copy of these databases and not separate copies for each node. so a sql server setting (if changed) persists even if it fails over to other node.
[by sql server setting i refer to those changes which are stored in system databases and not in the registry]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply