SQL Server Performance

blade server and a rack-mounted server in the same SQL 2008 R2 database cluster

Discussion in 'SQL Server 2008 Clustering' started by madduri, Mar 10, 2011.

  1. madduri New Member

    Hi,
    Can we configure sql server 2008 r2 database clustering between blade server and a rack-mounted server?
  2. satya Moderator

    SQL Server do not know or care about whether its a blade-server or rack-mounted, in any case you must ensure that the disks are properly configured for scalability. Only in case of Failover Clustering you may have to stick with recommended hardware and software levels.
    BTW what is the requirement here?
  3. madduri New Member

    Thank you for the response!
    We are planning to build a new sql server cluster for our SQL Server 2008 R2 databases. We are planning to use a blade server for the active node and a rack mounted server for the passive node which again might get replaced with a blade server in future. We just want to know if there will be any problems in doing so.
  4. satya Moderator

    Ok, i don't say that you will not get problems but it is a best practice to keep up the similar hardware and software specifications between nodes.
    FYI, A failover cluster instance can run on one or more computers that are participating nodes of a failover cluster. A failover cluster instance contains:
    • A combination of one or more disks in a Microsoft Cluster Service (MSCS) cluster group, also known as a resource group. Each resource group can contain at most one instance of SQL Server.

      • A network name for the failover cluster instance.

        • One or more IP addresses assigned to the failover cluster instance.

          • One instance of SQL Server that includes SQL Server, SQL Server Agent, the Full-text Search (FTS) service, and Replication. You can install a failover cluster with SQL Server only, Analysis Services only, or SQL Server and Analysis Services.
        • BTW, how busy the SQL server will be in terms of usage.
  5. madduri New Member

    This will be little busy. This will be our consolidated server with multiple instances. I tried to look up for possible issues with this combination of nodes but is hard to find anything online. Thank you for the input.
  6. satya Moderator

    Well thats the point, all the articles on web always recommends similar hardware between the nodes. As in your case you are saying the other node will be fixed soon with similar hardware, then you can continue with a constant monitoring in place.
    FYI

Share This Page