0

I have several different workloads I'd like to consolidate into the same Sql 2012/2014 instance.

  • Cognos/OLAP is burst oriented and users are accustomed to a response delay
  • Web databases that require immediate response (user authentication)

Is there any way to leverage SQL to partition these workloads?

1

You can install both on the same instance, If the performance is an issue you can use the resource govenor to make sure that the web database gets the lion's share of the resouces.

Security wise I would reccomend to separate the two by using different instances but if you are careful in setting up security this should be no issue.

  • Great points - most important thing is to do some thorough load testing before implementing any sort of combining strategy to make sure it works for your specific SLAs. Making them contained databases may also be of interest to you as well. – LowlyDBA Oct 13 '16 at 20:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for?Browse other questions tagged or ask your own question.