SQL Instance Articheture

I'm running a legal SQL Standard server with 1 instance for our SolareWinds database (awesome product).  Howerver, I have been tasked to move our WSUS and Mcafee AV databases over too the same server.  The server can handle the workload, that's not an issue, my question is should I create a seperate Instance for each applicaiton?  Or should I just add them too the same instance.  The reason I ask is because I know I can control the memory allocation at the instance level, not at the DB.  So what is the best practice for this?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark BillExchange, AD, SQL, VMware, HPE, 3PAR, FUD, Anti MS Tekhnet, Pro EE, #1Commented:
Seperate instance without doubt.

Mcafee depending on the size of your organization can be pretty hefty on the back end DB wise.
ste5anSenior DeveloperCommented:
Afaik WSUS and McAfee have a setup database sub-section in their install, which installs their own instance.

So go for separate instances. As you already said, it's about memory allocation and the possibility to restart those instances and free memory on demand.
Mark BillExchange, AD, SQL, VMware, HPE, 3PAR, FUD, Anti MS Tekhnet, Pro EE, #1Commented:
Also make sure you can add more resources, and I definetly would not add anything else to this SQL server.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
There are few things to consider when deciding whether you want to consolidate in one instance or multiple instances:

1.  Security:  Will different teams/groups/vendors need access to the instance.  If yes then separate instances
2.  Resources:  SolarWinds in our environment generates lots of IO and log files of close to 10 GB on a daily basis.  If you want to allocate specific CPU/Cores to each application DB or memory then go with separate instances
3.  TempDB:  All applications will use the same TempDB if they are consolidated in the same instance
4.  Version/Patch level:  If all applications cannot be installed under the same version or utilize or work under the same patch level then go with separate instances
5.  Specific requirements:  Specific requirements such as Max Degree of Parallelism, collation, etc. will also require you to create separate instances

If you have one IT team that manages all the applications and resource utilization is not an issue (i.e. small environment) then consolidating into one instance should not be an issue.  I have 3 SQL servers with total of 15 to 20 instances due to constraints where I have total of close to 400 DBs totalling few TBs of data.  It all depends on your environment, size, work-load, administration model, etc.

I would recommend you start with all DBs in the same instance providing you do not have any restrictions such as multiple teams or vendors requiring sysadmin roles and monitor.  If needed be then you could split them.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
Mach03, do you still need help with this question?
Mach03Author Commented:

Thank you so much for your answer, you nailed it.  I didn't even think about the secure side of it, since it's just a scipt, but long-term maintenance could be an isuse.

Sorry for the delay in my response.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.