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 59 mins ago
jadarnel27
3,7451330
asked 1 hour ago
Craig PCraig P
111
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 59 mins ago
jadarnel27
3,7451330
asked 1 hour ago
Craig PCraig P
111
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 59 mins ago
jadarnel27
3,7451330
asked 1 hour ago
Craig PCraig P
111
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 59 mins ago
jadarnel27
3,7451330
asked 1 hour ago
Craig PCraig P
111
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 59 mins ago
jadarnel27
3,7451330
asked 1 hour ago
Craig PCraig P
111
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 59 mins ago
jadarnel27
3,7451330
edited 59 mins ago
jadarnel27
3,7451330
edited 59 mins ago
jadarnel27
3,7451330
3,7451330
asked 1 hour ago
Craig PCraig P
111
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 1 hour ago
Craig PCraig P
111
asked 1 hour ago
Craig PCraig P
111
111
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 |
2 Answers
2
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 55 mins ago
jadarnel27jadarnel27
3,7451330
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 AOAG 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 mem) for any extended time, you do not have to adjust the MaxMem instance level setting because of a lower setting.
answered 1 hour ago
rvsc48rvsc48
32016
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
2 Answers
2
active
oldest
votes
2 Answers
2
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 55 mins ago
jadarnel27jadarnel27
3,7451330
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 55 mins ago
jadarnel27jadarnel27
3,7451330
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 55 mins ago
jadarnel27jadarnel27
3,7451330
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 55 mins ago
jadarnel27jadarnel27
3,7451330
answered 55 mins ago
jadarnel27jadarnel27
3,7451330
answered 55 mins ago
jadarnel27jadarnel27
3,7451330
answered 55 mins ago
jadarnel27jadarnel27
3,7451330
3,7451330
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 AOAG 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 mem) for any extended time, you do not have to adjust the MaxMem instance level setting because of a lower setting.
answered 1 hour ago
rvsc48rvsc48
32016
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 AOAG 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 mem) for any extended time, you do not have to adjust the MaxMem instance level setting because of a lower setting.
answered 1 hour ago
rvsc48rvsc48
32016
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 AOAG 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 mem) for any extended time, you do not have to adjust the MaxMem instance level setting because of a lower setting.
answered 1 hour ago
rvsc48rvsc48
32016
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 AOAG 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 mem) for any extended time, you do not have to adjust the MaxMem instance level setting because of a lower setting.
answered 1 hour ago
rvsc48rvsc48
32016
answered 1 hour ago
rvsc48rvsc48
32016
answered 1 hour ago
rvsc48rvsc48
32016
answered 1 hour ago
rvsc48rvsc48
32016
32016
add a comment |
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
