Multiple SQL Standard Instances on 4 Processor/32-core Server

Posted by Theowood on Server Fault See other posts from Server Fault or by Theowood
Published on 2013-07-02T10:54:47Z Indexed on 2013/07/02 11:07 UTC
Read the original article Hit count: 202

Filed under:

instances

We have a large 4 processor/32-core server with 192GB of memory available in the data center and over twenty small SQL Standard databases to consolidate. They are a mix of SQL 2012 and 2008 R2 for 3rd-party apps.

Is there any issue with simply installing two instances of SQL Standard on the server - one for 2012 and one for 2008 R2 ? Each instance will use up to 64GB out of the 192GB and 16 cores. If we did this with Enterprise, the licensing would be a fortune and the Enterprise features are not needed.

Related posts about instances

Recreating OMS instances in a HA environment when instances on all nodes are lost

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle highly recommends deploying EM in a HA environment. The best practices for HA deployments, backup and housekeeping of your Enterprise Manager environment are documented in the Oracle Enterprise Manager Advanced Configuration Guide. It is imperative that there is a good disaster recovery plan… >>> More
creational pattern for instances depending on multiple subclass instances

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a problem, for that I was not able to identify a suitable design pattern. I want to create instances depending on a given type that has been passed to a factory method. What I am doing until now is the following: T create(SuperType x) { if (x instanceof SubType1) { // do some stuff… >>> More
Purging SOA Instances

as seen on Oracle Blogs - Search for 'Oracle Blogs'
All, If your running Oracle SOA suite in a high thoughput environment you'll probably discover that your dehydration store will get large, and larger if you dont manage it properly. There are many strategies in manging how to purge this, and this document recently released by Oracle details them… >>> More
Name a Byobu session?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Is there a way to create identifiable Byobu sessions so that when I've got multiple sessions running, the byobu-select-session menu gives me a list of sessions I can recognize, as opposed to non-descript tmux port numbers? In an ideal world, it would be great to be able to both start a session giving… >>> More
2nd instance of Firefox does not obey GTK2 customizations

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Hi On Ubuntu 10.10 I started a 2nd instance of Firefox using the command: $ firefox -ProfileManager -no-remote & Created a new profile and everything works smoothly except for the fact that this instance of FF does not obey by GTK2 customizations that I have placed in ~/.gtkrc-2.0 Moreover… >>> More

Developer IT