Consolidating SQL Server databases into a New Server vs. Existing ServerBackup SQL DataBase to C$SQL Server...
Is it possible to narrate a novel in a faux-historical style without alienating the reader?
Why is it that Bernie Sanders always called a "socialist"?
How can guns be countered by melee combat without raw-ability or exceptional explanations?
Why is perturbation theory used in quantum mechanics?
Determinant of 3x3 matrix by cofactor expansion
typeof generic and casted type
How do I add a strong "onion flavor" to the biryani (in restaurant style)?
Boss asked me to sign a resignation paper without a date on it along with my new contract
Does the double-bladed scimitar's special attack let you use your ability modifier for the damage of the attack?
Why is Shelob considered evil?
How can I differentiate duration vs starting time
Can a Way of Shadow Monk use Shadow Step to teleport to a dark ceiling and then body slam another creature?
Trying to make a 3dplot
Disk space full during insert, what happens?
Is it possible to detect 100% of SQLi with a simple regex?
Do the speed limit reductions due to pollution also apply to electric cars in France?
How bad is a Computer Science course that doesn't teach Design Patterns?
Will the duration of traveling to Ceres using the same tech developed for going to Mars be proportional to the distance to go to Mars or not?
Including proofs of known theorems in master's thesis
What does "don't have a baby" imply or mean in this sentence?
Are all power cords made equal?
Can I legally make a website about boycotting a certain company?
How to store all ctor parameters in fields
Graphical modeler calculator missing in QGIS3
Consolidating SQL Server databases into a New Server vs. Existing Server
Backup SQL DataBase to C$SQL Server 2012 AlwaysOn: need to automatically add databases by script- T-sql or PowerShellHow to merge data sets without including redundant rows?Consolidating 2 Tables with same ValuesData Files Outgrowing Hardware - Split the File?Moving data from MS Access to MS SQL ServerUpgrading SQL Server from 2008 to 2012 doesn't respect existing install / instance pathsBest data upload formatsConfiguring physical storage for a Microsoft SQL Server installationSQL Server AAGs/Possible Endpoint contention/Synchronous replication to WAN Secondary
Currently I am working on a project that requires me to consolidate 3 servers into 1 server, so I am trying to find the best method at the moment. Right now my options are:
- Consolidate the 3 servers into 1 separate server and set up a high availability cluster on it
- Consolidate the 3 servers into an existing server that already has a clustered environment.
As of now, I am leaning towards the 1st option because the existing server currently holds over 40 databases and performance wise, I don't think it will be a good idea to add more databases into it. I was also told to use perfmon to look at cpu, memory, disks, etc. but I'm still trying to understand how to use it efficiently.
This is my first time working with server/database consolidation in SQL server, so I'm not sure where exactly I can find pros and cons to those 2 options. It'll be very helpful if I can get an answer to guide me where and what I should look at to compare those 2 options! Thank you in advance!
sql-server-2012 performance availability-groups
asked 8 mins ago
BrianBrian
1
New contributor
Brian 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 |
Currently I am working on a project that requires me to consolidate 3 servers into 1 server, so I am trying to find the best method at the moment. Right now my options are:
- Consolidate the 3 servers into 1 separate server and set up a high availability cluster on it
- Consolidate the 3 servers into an existing server that already has a clustered environment.
As of now, I am leaning towards the 1st option because the existing server currently holds over 40 databases and performance wise, I don't think it will be a good idea to add more databases into it. I was also told to use perfmon to look at cpu, memory, disks, etc. but I'm still trying to understand how to use it efficiently.
This is my first time working with server/database consolidation in SQL server, so I'm not sure where exactly I can find pros and cons to those 2 options. It'll be very helpful if I can get an answer to guide me where and what I should look at to compare those 2 options! Thank you in advance!
sql-server-2012 performance availability-groups
asked 8 mins ago
BrianBrian
1
New contributor
Brian 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 |
Currently I am working on a project that requires me to consolidate 3 servers into 1 server, so I am trying to find the best method at the moment. Right now my options are:
- Consolidate the 3 servers into 1 separate server and set up a high availability cluster on it
- Consolidate the 3 servers into an existing server that already has a clustered environment.
As of now, I am leaning towards the 1st option because the existing server currently holds over 40 databases and performance wise, I don't think it will be a good idea to add more databases into it. I was also told to use perfmon to look at cpu, memory, disks, etc. but I'm still trying to understand how to use it efficiently.
This is my first time working with server/database consolidation in SQL server, so I'm not sure where exactly I can find pros and cons to those 2 options. It'll be very helpful if I can get an answer to guide me where and what I should look at to compare those 2 options! Thank you in advance!
sql-server-2012 performance availability-groups
asked 8 mins ago
BrianBrian
1
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Currently I am working on a project that requires me to consolidate 3 servers into 1 server, so I am trying to find the best method at the moment. Right now my options are:
- Consolidate the 3 servers into 1 separate server and set up a high availability cluster on it
- Consolidate the 3 servers into an existing server that already has a clustered environment.
As of now, I am leaning towards the 1st option because the existing server currently holds over 40 databases and performance wise, I don't think it will be a good idea to add more databases into it. I was also told to use perfmon to look at cpu, memory, disks, etc. but I'm still trying to understand how to use it efficiently.
This is my first time working with server/database consolidation in SQL server, so I'm not sure where exactly I can find pros and cons to those 2 options. It'll be very helpful if I can get an answer to guide me where and what I should look at to compare those 2 options! Thank you in advance!
sql-server-2012 performance availability-groups
sql-server-2012 performance availability-groups
asked 8 mins ago
BrianBrian
1
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 mins ago
BrianBrian
1
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 mins ago
BrianBrian
1
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 mins ago
BrianBrian
1
asked 8 mins ago
BrianBrian
1
1
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Brian 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 |
0
active
oldest
votes
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
});
}
});
Brian 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%2f230515%2fconsolidating-sql-server-databases-into-a-new-server-vs-existing-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Brian is a new contributor. Be nice, and check out our Code of Conduct.
Brian is a new contributor. Be nice, and check out our Code of Conduct.
Brian is a new contributor. Be nice, and check out our Code of Conduct.
Brian 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.
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%2f230515%2fconsolidating-sql-server-databases-into-a-new-server-vs-existing-server%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
