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

• tharwood 94756

  SSC Veteran

  Points: 219

  More actions

  July 2, 2013 at 4:28 am

  #276914

  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.

• Jeffrey Williams

  SSC Guru

  Points: 90256

  More actions

  July 2, 2013 at 11:25 am

  #1629224

  As long as you balance the resources between the instances - there shouldn't be any issues.

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs