SQL Server Performance

adding disk to existing cluster

Discussion in 'SQL Server 2005 Clustering' started by v1sion, Nov 9, 2006.

  1. v1sion New Member

    I have to add disk to an existing cluster

    I am not sure of the steps required.
    we have 2 instances running.

    thanks
  2. bradmcgehee New Member

    If you are adding an additional disk to a currently existing RAID array, then you would add it to the array per the manufacturer's instructions. This would in effect increase the size of your pre-existing array and clustering is not affected.

    But, if this new disk will not be part of an existing array, but be a new disk resource, then you have more work to do.

    Here's the big picture of what you need to do:

    1) Install the disk per the manufacturers instructions to the shared array.
    2) Add the disk to the OS of each node of the server using Disk Administrator.
    3) Add the disk as a disk resource of the existing cluster. This new disk resource should be part of the SQL Server resource group. Since you have two instances, this new disk resource can only be assigned to one of the instances, not both.
    4) Now, the disk should be available to SQL Server and you can use it however best is meets your needs to deal with the expanding size of your databases.

    -----------------------------
    Brad M. McGehee, SQL Server MVP
  3. sivasql New Member

    1. Start Cluster Administrator.

    2. Fail all disk resources that will be added to the SQL Server virtual server to the same node that currently owns the SQL Server resources.

    3. Drag and drop the additional disk resources to the folder containing the SQL Server resources to move them. A message will be displayed.

    4. In the Move Resources dialog box,, click Yes.


    5. Take the SQL Server resource offline by right-clicking it and selecting Bring Offline. Or, you can use SQL Server Service Manager and stop SQL Server. Both methods are supported.

    6. Right-click the SQL Server resource and then click Properties.

    7. In the Properties dialog box, click the Dependencies tab, and then click Modify.

    8. In the Modify Dependencies dialog box, shown in the available resources for the cluster appear in the Available Resources list. Select the drives to add, click the arrow to move the resource to the Dependencies list, and then click OK.



    To verify that the resource is now a dependency, in the Properties dialog box click the Dependencies tab.



    To ensure all of your drives are added to SQL Server properly, you can do two things:

    1. Execute the following Transact-SQL query:

    2. select * from ::fn_servershareddrives() --- SQL 2000

    3. select * from sys.dm_io_cluster_shared_drives() -- SQL 2005 / sQL 2008


Share This Page