Consolidating SQL Server databases into a New Server vs. Existing ServerBackup SQL DataBase to C$SQL Server...
What is the reward?
Identical projects by students at two different colleges: still plagiarism?
Are all power cords made equal?
What could cause an entire planet of humans to become aphasic?
What really causes series inductance of capacitors?
Can a Way of Shadow Monk use Shadow Step to teleport to a dark ceiling and then body slam another creature?
Why does this quiz question say that protons and electrons do not combine to form neutrons?
Determinant of 3x3 matrix by cofactor expansion
What does an unprocessed RAW file look like?
What is formjacking?
Why is Shelob considered evil?
Does the double-bladed scimitar's special attack let you use your ability modifier for the damage of the attack?
Short story about a man betting a group he could tell a story, and one of them would disappear and the others would not notice
Is there a way to pause a running process on Linux systems and resume later?
Coworker asking me to not bring cakes due to self control issue. What should I do?
Does しかたない imply disappointment?
Why write a book when there's a movie in my head?
What is the Buddhist view in Socratic questioning?
Sets which are both Sum-free and Product-free.
Proving the Borel-Cantelli Lemma
How many copper coins fit inside a cubic foot?
How can changes in personality/values of a person who turned into a vampire be explained?
Python to write multiple dataframes and highlight rows inside an excel file
Is there a name for this series?
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 with 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 2 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 with 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 2 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 with 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 2 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 with 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 2 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 2 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 2 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 2 mins ago
BrianBrian
1
asked 2 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
