Do SQL Servers in a cluster need to have the same memory?
I have two servers in always on failover configuration with windows clustering underneath.
Do both servers need to have the same memory?
One of our DBs that uses a lot of memory is not in the AG, so ideally I don't want to give the secondary server the same memory as the primary because - it will never need to run the big DB.
sql-server sql-server-2014 availability-groups
edited yesterday
jadarnel27
3,8341330
asked yesterday
Craig PCraig P
262
New contributor
Craig P is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have two servers in always on failover configuration with windows clustering underneath.
Do both servers need to have the same memory?
One of our DBs that uses a lot of memory is not in the AG, so ideally I don't want to give the secondary server the same memory as the primary because - it will never need to run the big DB.
sql-server sql-server-2014 availability-groups
edited yesterday
jadarnel27
3,8341330
asked yesterday
Craig PCraig P
262
New contributor
Craig P is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have two servers in always on failover configuration with windows clustering underneath.
Do both servers need to have the same memory?
One of our DBs that uses a lot of memory is not in the AG, so ideally I don't want to give the secondary server the same memory as the primary because - it will never need to run the big DB.
sql-server sql-server-2014 availability-groups
edited yesterday
jadarnel27
3,8341330
asked yesterday
Craig PCraig P
262
New contributor
Craig P is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have two servers in always on failover configuration with windows clustering underneath.
Do both servers need to have the same memory?
One of our DBs that uses a lot of memory is not in the AG, so ideally I don't want to give the secondary server the same memory as the primary because - it will never need to run the big DB.
sql-server sql-server-2014 availability-groups
sql-server sql-server-2014 availability-groups
edited yesterday
jadarnel27
3,8341330
asked yesterday
Craig PCraig P
262
New contributor
Craig P is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited yesterday
jadarnel27
3,8341330
asked yesterday
Craig PCraig P
262
New contributor
Craig P is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited yesterday
jadarnel27
3,8341330
edited yesterday
jadarnel27
3,8341330
edited yesterday
jadarnel27
3,8341330
3,8341330
asked yesterday
Craig PCraig P
262
New contributor
Craig P is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Craig PCraig P
262
asked yesterday
Craig PCraig P
262
262
New contributor
Craig P is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Craig P is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Craig P is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
There's no functional requirement for servers in a cluster to have the exact same specs (memory, CPU, etc). So you can definitely set it up this way.
To some extent, you've answered your own question. To put it differently - if one of the servers in the cluster will never be running the same workload as the other, you should tune that server appropriately for its workload. It would be a waste of resources to do otherwise.
answered yesterday
jadarnel27jadarnel27
3,8341330
add a comment |
Thinking about the future, databases will come and go most likely. Do you want that extra pain of remembering that one of the servers in the AG configuration is not set the same? We always set the memory the same in all servers involved.
Also, if you have to run all databases on one server (the one with lesser memory) for any extended time, you do not have to adjust the "max server memory" instance level setting because of a lower amount of available physical memory.
edited yesterday
jadarnel27
3,8341330
answered yesterday
rvsc48rvsc48
34816
add a comment |
They need not have same amount of memory, there is is no pre-requisite as such. However it would be good to allocate sufficient memory that would take care to run databases if AG was to fail-over and databases were to be online on the other server instance.
I would suggest that you calculate the Memory requirement separately for databases part of Always ON and standalone ones and accordingly provision it accordingly across servers/instances.
answered yesterday
sajeeshsajeesh
311
Great, thanks for your input
– Craig P
12 hours ago
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Craig P is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f226510%2fdo-sql-servers-in-a-cluster-need-to-have-the-same-memory%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
There's no functional requirement for servers in a cluster to have the exact same specs (memory, CPU, etc). So you can definitely set it up this way.
To some extent, you've answered your own question. To put it differently - if one of the servers in the cluster will never be running the same workload as the other, you should tune that server appropriately for its workload. It would be a waste of resources to do otherwise.
answered yesterday
jadarnel27jadarnel27
3,8341330
add a comment |
There's no functional requirement for servers in a cluster to have the exact same specs (memory, CPU, etc). So you can definitely set it up this way.
To some extent, you've answered your own question. To put it differently - if one of the servers in the cluster will never be running the same workload as the other, you should tune that server appropriately for its workload. It would be a waste of resources to do otherwise.
answered yesterday
jadarnel27jadarnel27
3,8341330
add a comment |
There's no functional requirement for servers in a cluster to have the exact same specs (memory, CPU, etc). So you can definitely set it up this way.
To some extent, you've answered your own question. To put it differently - if one of the servers in the cluster will never be running the same workload as the other, you should tune that server appropriately for its workload. It would be a waste of resources to do otherwise.
answered yesterday
jadarnel27jadarnel27
3,8341330
There's no functional requirement for servers in a cluster to have the exact same specs (memory, CPU, etc). So you can definitely set it up this way.
To some extent, you've answered your own question. To put it differently - if one of the servers in the cluster will never be running the same workload as the other, you should tune that server appropriately for its workload. It would be a waste of resources to do otherwise.
answered yesterday
jadarnel27jadarnel27
3,8341330
answered yesterday
jadarnel27jadarnel27
3,8341330
answered yesterday
jadarnel27jadarnel27
3,8341330
answered yesterday
jadarnel27jadarnel27
3,8341330
3,8341330
add a comment |
add a comment |
Thinking about the future, databases will come and go most likely. Do you want that extra pain of remembering that one of the servers in the AG configuration is not set the same? We always set the memory the same in all servers involved.
Also, if you have to run all databases on one server (the one with lesser memory) for any extended time, you do not have to adjust the "max server memory" instance level setting because of a lower amount of available physical memory.
edited yesterday
jadarnel27
3,8341330
answered yesterday
rvsc48rvsc48
34816
add a comment |
Thinking about the future, databases will come and go most likely. Do you want that extra pain of remembering that one of the servers in the AG configuration is not set the same? We always set the memory the same in all servers involved.
Also, if you have to run all databases on one server (the one with lesser memory) for any extended time, you do not have to adjust the "max server memory" instance level setting because of a lower amount of available physical memory.
edited yesterday
jadarnel27
3,8341330
answered yesterday
rvsc48rvsc48
34816
add a comment |
Thinking about the future, databases will come and go most likely. Do you want that extra pain of remembering that one of the servers in the AG configuration is not set the same? We always set the memory the same in all servers involved.
Also, if you have to run all databases on one server (the one with lesser memory) for any extended time, you do not have to adjust the "max server memory" instance level setting because of a lower amount of available physical memory.
edited yesterday
jadarnel27
3,8341330
answered yesterday
rvsc48rvsc48
34816
Thinking about the future, databases will come and go most likely. Do you want that extra pain of remembering that one of the servers in the AG configuration is not set the same? We always set the memory the same in all servers involved.
Also, if you have to run all databases on one server (the one with lesser memory) for any extended time, you do not have to adjust the "max server memory" instance level setting because of a lower amount of available physical memory.
edited yesterday
jadarnel27
3,8341330
answered yesterday
rvsc48rvsc48
34816
edited yesterday
jadarnel27
3,8341330
edited yesterday
jadarnel27
3,8341330
edited yesterday
jadarnel27
3,8341330
3,8341330
answered yesterday
rvsc48rvsc48
34816
answered yesterday
rvsc48rvsc48
34816
answered yesterday
rvsc48rvsc48
34816
34816
add a comment |
add a comment |
They need not have same amount of memory, there is is no pre-requisite as such. However it would be good to allocate sufficient memory that would take care to run databases if AG was to fail-over and databases were to be online on the other server instance.
I would suggest that you calculate the Memory requirement separately for databases part of Always ON and standalone ones and accordingly provision it accordingly across servers/instances.
answered yesterday
sajeeshsajeesh
311
Great, thanks for your input
– Craig P
12 hours ago
add a comment |
They need not have same amount of memory, there is is no pre-requisite as such. However it would be good to allocate sufficient memory that would take care to run databases if AG was to fail-over and databases were to be online on the other server instance.
I would suggest that you calculate the Memory requirement separately for databases part of Always ON and standalone ones and accordingly provision it accordingly across servers/instances.
answered yesterday
sajeeshsajeesh
311
Great, thanks for your input
– Craig P
12 hours ago
add a comment |
They need not have same amount of memory, there is is no pre-requisite as such. However it would be good to allocate sufficient memory that would take care to run databases if AG was to fail-over and databases were to be online on the other server instance.
I would suggest that you calculate the Memory requirement separately for databases part of Always ON and standalone ones and accordingly provision it accordingly across servers/instances.
answered yesterday
sajeeshsajeesh
311
They need not have same amount of memory, there is is no pre-requisite as such. However it would be good to allocate sufficient memory that would take care to run databases if AG was to fail-over and databases were to be online on the other server instance.
I would suggest that you calculate the Memory requirement separately for databases part of Always ON and standalone ones and accordingly provision it accordingly across servers/instances.
answered yesterday
sajeeshsajeesh
311
answered yesterday
sajeeshsajeesh
311
answered yesterday
sajeeshsajeesh
311
answered yesterday
sajeeshsajeesh
311
311
Great, thanks for your input
– Craig P
12 hours ago
add a comment |
Great, thanks for your input
– Craig P
12 hours ago
Great, thanks for your input
– Craig P
12 hours ago
Great, thanks for your input
– Craig P
12 hours ago
add a comment |
Craig P is a new contributor. Be nice, and check out our Code of Conduct.
Craig P is a new contributor. Be nice, and check out our Code of Conduct.
Craig P is a new contributor. Be nice, and check out our Code of Conduct.
Craig P is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f226510%2fdo-sql-servers-in-a-cluster-need-to-have-the-same-memory%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
