locked
Run two version RRS feed

  • Question

  • Is it possible to run two SQL Server version ( one is 2000 the other 2005 - can use different instance )

    Than on the CPU the SQL 2000 will utilize 6 and for 2005 utilize all CPU (24)

     

    Tuesday, May 31, 2011 3:23 AM

Answers

  • Hello,

    You can have two instances of SQL Server 2000 and SQL Server 2005 coexisting in the same box with no problem.

     

    Please use CPU affinity mask to configure the SQL 2000 to use specific CPUs. Do nothing for SQL Server 2005.

    http://msdn.microsoft.com/en-us/library/aa196717(SQL.80).aspx

    Consider to balance memory usage across both instances also:

    http://msdn.microsoft.com/en-us/library/ms178067(v=SQL.90).aspx (Running multiple instances of SQL Server)

     

    Hope this helps.  


    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Mr. Wharty Wednesday, June 1, 2011 4:36 AM
    • Marked as answer by Wiryono Lauw Wednesday, June 1, 2011 7:40 AM
    Tuesday, May 31, 2011 11:15 AM
  • Hello,

    At the operating system level, processes without affinity may use processors to which another processes are constrained. This means that SQL Server 2005 may use any of the CPUs even when the SQL Server 2000 is constrained to specific CPUs.

    Assign “max server memory” to each instance based on the workload expected, but make sure the sum of both max server memory values should not exceed the physical RAM. Leave some RAM available for the virtual address space.

    About the AWE, remember to set the lock pages in memory option.

    Decide what version of SQL Server you will install based on your budget and licenses available, but take in consideration SQL Server 2000 is no longer supported and SQL Server 2005 is supported only with SP4 installed.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     

    • Marked as answer by Wiryono Lauw Wednesday, June 1, 2011 7:40 AM
    Wednesday, June 1, 2011 4:26 AM

All replies

  • Hello,

    You can have two instances of SQL Server 2000 and SQL Server 2005 coexisting in the same box with no problem.

     

    Please use CPU affinity mask to configure the SQL 2000 to use specific CPUs. Do nothing for SQL Server 2005.

    http://msdn.microsoft.com/en-us/library/aa196717(SQL.80).aspx

    Consider to balance memory usage across both instances also:

    http://msdn.microsoft.com/en-us/library/ms178067(v=SQL.90).aspx (Running multiple instances of SQL Server)

     

    Hope this helps.  


    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Mr. Wharty Wednesday, June 1, 2011 4:36 AM
    • Marked as answer by Wiryono Lauw Wednesday, June 1, 2011 7:40 AM
    Tuesday, May 31, 2011 11:15 AM
  • | Please use CPU affinity mask to configure the SQL 2000 to use specific CPUs. Do nothing for SQL Server 2005.

    Yes I already set the SQL 2000 to use 6 CPU,

    For Sql 2005 will it automatically utilize all CPU ?

     

    | Consider to balance memory usage across both instances also:

    Due to some restriction i need to use 32bit OS with AWE and PAE enabled

    so it's mean 4 gig for each instance is the best ?

    For SQL 2000 using 4 and 8 gig doesn't give any perfromance improvement ....

     

    Oh What about two SQL 2000 ? is it possible ?

    I haven't bought SQL2005 and it's pretty expensive for my company :D



    Tuesday, May 31, 2011 11:05 PM
  • Hello,

    At the operating system level, processes without affinity may use processors to which another processes are constrained. This means that SQL Server 2005 may use any of the CPUs even when the SQL Server 2000 is constrained to specific CPUs.

    Assign “max server memory” to each instance based on the workload expected, but make sure the sum of both max server memory values should not exceed the physical RAM. Leave some RAM available for the virtual address space.

    About the AWE, remember to set the lock pages in memory option.

    Decide what version of SQL Server you will install based on your budget and licenses available, but take in consideration SQL Server 2000 is no longer supported and SQL Server 2005 is supported only with SP4 installed.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     

    • Marked as answer by Wiryono Lauw Wednesday, June 1, 2011 7:40 AM
    Wednesday, June 1, 2011 4:26 AM
  • Ouch

    Another new things.. 

    I'll check on the lock page, never use it...

    Wednesday, June 1, 2011 7:40 AM
  • Using two different instance with two different sql version, the tcp ip connection port is required to be different ?

    How about when same version different instance name ?


    Tuesday, June 7, 2011 9:05 AM
  • Hello,

    Each instance needs to listen on a different port. Default instance usually listen on 1433.  SQL Server Browser service is required when a named instance is installed.

     

    Hope this helps.  


    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, June 7, 2011 1:14 PM