SQL Server Performance

Confused ! Need Help?

Discussion in 'SQL Server Clustering' started by imranmcse, Aug 5, 2006.

  1. imranmcse New Member

    Please answer following questions?

    1-Before installing microsoft cluster+SQL Virtual Server I should install normal installation of SQL2000 on both nodes.

    2-I have 8x72 GB Ultra320 SCSI in MSA1500 storagebox. What is your recommendation how should I make drives and which RAID system for quroum,DB (db is almost 5 to 10 GB), and T-Log should I use?

    3-I have only one database instance, so still I should configure MSDTC or no need?

    4- Can I use the same drive and cluster group for Quorum and MSDTC?

    5-On windows 2003 when SQL virtual server will finish installation. Then the SQL SP4 I should install on one node or I have to install it one by one on all nodes of the cluster.I am using Active/Passive scenario.

    Pls reply my questions.Then I will start my projetct.....
  2. Argyle New Member

    1.
    No, you just install a virtual sql server. You install from one node and it performs all needed operations on both nodes.

    2.
    Depends on the activity on your databases. At least split data and log in two seperate raids. One example is RAID1 for log, and RAID5 or RAID10 for Data.

    3.
    Yes, configure it.

    4.
    Yes if your MSDTC activity is low.

    5.
    You install from one node and it performs all needed operations on both nodes. Make sure you install with an account that have administrative rights on all nodes and that the remote registry service is running on both nodes. There is detailed info in the readme file.
  3. imranmcse New Member

    quote: 1.
    No, you just install a virtual sql server. You install from one node and it performs all needed operations on both nodes.

    2.
    Depends on the activity on your databases. At least split data and log in two seperate raids. One example is RAID1 for log, and RAID5 or RAID10 for Data.

    3.
    Yes, configure it.

    4.
    Yes if your MSDTC activity is low.

    5.
    You install from one node and it performs all needed operations on both nodes. Make sure you install with an account that have administrative rights on all nodes and that the remote registry service is running on both nodes. There is detailed info in the readme file.
    Thanks a lot for your reply.

    One thing more shoud I install MS Data Access Components 2.6 before SQL virtual Server. I am using Windows 2003 EE R2.
  4. satya Moderator

  5. imranmcse New Member

    I am really thankfull to Satya SKJ and all those who has replied, My confusion has been solved...<br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
  6. Priyakara New Member

    RE : 4- Can I use the same drive and cluster group for Quorum and MSDTC?

    I Think Better you can configure Quorum in Separate Partition ( even in the Same Disk)

Share This Page