August 31, 2022 at 4:05 pm
Hi,
When I join my current company we had plenty of single porpoise SQL instances and my boss (senior DBA) indicated an consolidation effort... and left company. I am trying to proceed with his plan which was clear at the beginning but I encountered a few applications for which I have serious doubts.
I wander how to proceed with applications that are part of the infrastructure (for example Citrix, monitoring tools) or used by information security team. Looking at the workload only, putting them all together with business apps should not be a problem.... but it feels a little bit weird and I wander if I am missing something.
Is there any technical reason why DBs used by business application should not be at the same instance as Infra or Security ones? Excluding business apps and considering infra and security only... is there a reason why they should not be put together on a single instance?
August 31, 2022 at 6:00 pm
Could you please provide more details on what you are trying to achieve, like a description of before and after?
😎
Answering the question of separation of instances, "it all depends", there is no one size that fits all!
I've consolidated tens of servers with tens of databases each into a single server running a number of instances, such things are not a problem, but providing an answer to your good question at this point would be guessing and making assumptions, I cannot do that. 😉
September 1, 2022 at 8:26 am
Thanks for such quick answer Eirikur.
Could you please provide more details on what you are trying to achieve, like a description of before and after?
I have much more servers that I spouse to have, some of them are express edition, but most of them are using payed versions of SQL... and many of them are using old un-supported versions of SQL. So the description before is X servers with all possible versions starting from 2005. Most of them are used by business, but I have a few dedicated for infra related applications (for example Citrix, SQL monitoring tool etc) and a few dedicated for security application (for example anti various).
The current architecture is coursing some problems (cost, difficult management, some express editions starting to reach limits, and so one) so previous senior DBA scratch high level plan how to consolidate whole environment to Y instances that are on version 2019.
I was working on consolidation business applications but I need to pick up apps that are not really business ones. All of them are relatively small and looking at the workload itself they should fit on one of instances that I dedicated for business apps
So my question is exactly about description after. Should I consolidate whole environment to Y instances, or it should be Y+1 (as infra should be separated)+1 (as security should be separated). Or just Y + 1 (as infra and security can sit together)
I know that's a little bit general question.. but it really is about 'good practices' and can be paraphrase to:"it all depends" - depends on what? Does the porpoise of app is one of the factors?
September 2, 2022 at 5:21 pm
Sorry for the late response.
In short, a good practice for any migration is knowing what access and control methods are used by the applications on the current systems and making certain that those methods will work on the target system (2B or "to be").
I got many thoughts on this: Here is the first one "If there are any methods that utilise cmd or other direct OS functions? If so, then you need a VM as you will not have access to those on a managed or shared instance."
😎
The term "It all depends" means that one cannot answer a question without knowing the details of all the databases, all the applications, all the methods used and last but not least, all the expectations.
September 5, 2022 at 8:35 am
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply