none
How many instances can be installed on single computer RRS feed

  • Question

  • Hi,
    I wonder how many instances of SQL Server 2008 may be installed on single computer?
    Msi documentation says that 255 transforms may be applied to installation package so theoretically 255 instances may be installed. But are there actually any other restrictions in SQL Server 2008 installation package?
    Thank you.
    Monday, September 21, 2009 8:24 AM

Answers

All replies

  • Hi

    Yes 255 instances can be installed on a single machine.
    Based on the edition, the processor usage, memory usage requirements varies. The machine should be capable of such requirements for each instance.

    You can verify detailed information at
    http://msdn.microsoft.com/en-us/library/ms143506.aspx

    -Sreekar
    Monday, September 21, 2009 9:02 AM
  • According to below, you can have 50 instances, except for workgroup where 16 is supported. Unless on a cluster where 25 is supported:
    http://msdn.microsoft.com/en-us/library/ms143432.aspx
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    Tuesday, September 22, 2009 7:19 AM
    Moderator
  • Is your question intended more as an academic question or are you in a situation in which you are genuinely concerned about hitting this limit?
    Tuesday, September 22, 2009 11:46 AM
    Moderator
  • Tibork is right, According to 70-432 (SQL Server 2008 - Implementation and Maintenance) traing kit (the book I am using at the moment to prepair for the exam), you can have up to 16 instances for Standard, Workgroup, Express and Compact editions and up to 50 for Enterprise (the Developer and Eval editions which are really Enterprise editions).

    Hope that helps!

     

    Sunday, April 25, 2010 1:41 AM
  • 1) Is there any statistics about how many production SQL instances are installed on one machine in average?

    2) Machine with how many production SQL instances you've ever met in your experience?

    Thursday, February 9, 2012 1:02 PM