Size of a Root Disk for Mount Point

  • Is there a recommended size for the root disk when attaching mount points to it? It probably doesn't need to be large at all since all the data from SQL will be writing to the mount point. An example below:

    C: OS

    D: 1 GB

    D:\data <-- mount point to Disk3 (1 TB)

    D:\log <-- mount point to disk4 (500 GB)

    etc

    and for each SQL instance, each one will need it's own Root Drive in a clustered solution? So above is instance 1, instance 2 could be:

    E: 1 GB

    E:\data <-- Disk5(2 TB)

    E:\log <--Disk6(500 GB)

    etc

  • make the root disk as small as possible, i usually use a size of around 100MB. See my article at this link[/url] for more info

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Thanks - in an A/A cluster, each instance would need its own Root Disk, correct?

  • nocode99 (4/10/2012)


    Thanks - in an A/A cluster, each instance would need its own Root Disk, correct?

    Since the root disk becomes a dependency in the installed clustered instance group, create a new root drive for each new clustered instance.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply