SQL Server Performance Forum – Threads Archive
Confused ! Need Help?
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 8×72 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…..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.
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.
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.
Having SP4 on Clustered will update MDAC anyway.
http://www.aspfaq.com/show.asp?id=2543 a good one. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
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=’
‘ />]
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)
]]>