SQL Server Performance

Multiple instances on SQL cluster

Discussion in 'SQL Server Clustering' started by vivianyip, Feb 15, 2004.

  1. vivianyip New Member

    Hi All,

    I have couple question regarding SQL cluster.

    1) I have a two-node active/active cluster server, and I want to install 3 sql 2000 instances on each of the node(total of 6), is this possible? If yes, how many sql enterprise license do I need, 2 (one for each node) or 6 (one for each instance)?

    2) Is sql 2000 analysis services runs ok on sql cluster?

    Thanks & regards,
    Vivian
  2. Argyle New Member

    1.
    You can only have one default instance in an SQL 2000 cluster, all others will be named instances. It's different from SQL 7 where you could have two "default" instances (and no more). With SQL 2000, the entire cluster acts as a single server and you can install max one default instance and 15 named instances (or 16 named instances).

    In your case it would be:
    SQLCLUSTER
    SQLCLUSTERInstance1
    SQLCLUSTERInstance2
    SQLCLUSTERInstance3
    SQLCLUSTERInstance4
    SQLCLUSTERInstance5

    or
    SQLCLUSTERInstance1
    SQLCLUSTERInstance2
    SQLCLUSTERInstance3
    SQLCLUSTERInstance4
    SQLCLUSTERInstance5
    SQLCLUSTERInstance6

    How you divide them between the nodes is up to you. If you divide them among both servers then you need licences for both. If you put all instances on one server and the other is passive, you only need to license one server.

    2.
    Haven't run analysis services on a cluster so I can't say but I assume it's not much different.

    /Argyle

Share This Page