asked on

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?

Thanks!

Mark Bill

Seperate instance without doubt.

Mcafee depending on the size of your organization can be pretty hefty on the back end DB wise.

ste5an

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 Bill

Also make sure you can add more resources, and I definetly would not add anything else to this SQL server.

ASKER CERTIFIED SOLUTION

Mohammed Khawaja

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Vitor Montalvão

Mach03, do you still need help with this question?

Mach03

ASKER

Mohammed,

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.

Thanks!