• fasttrack2 (1/28/2014)


    1) In a Multi-Instance Cluster:What About for the SQL Instances Installations? (locally? On external Storage? On external Storage on same LUN)

    The binaries will be installed locally as will shared components, the system databases and user databases will reside on shared storage

    fasttrack2 (1/28/2014)


    2) In a Multi-Instance Cluster: Can the same LUN hold database disk files belonging to different Instances? (e.g.: LUN3 holds: DB1_mdf/ldf files and DW1_mdf/Ldf Files)

    No, all LUNs\disks assigned to 1 instance cannot be shared by another instance.

    fasttrack2 (1/28/2014)


    3) In a Multi-Instance Cluster: Is it possible to locate all the System Database files on the same LUN?

    I assume you mean all system databases for multiple instances?

    If so, then no separate shared storage is required

    fasttrack2 (1/28/2014)


    Definetely:

    Each Instnace needs own disks or the same disk may be shared between several Instances ?

    This is the same question as you asked above.

    No, all instances must use separate shared storage

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

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