SQL Server Performance Forum – Threads Archive
Virtual Server 2005 – SCSI Adapter QuestionHi, Has anyone run through this article on setting up a test cluster using Virtual Server 2005? http://www.sql-server-performance.com/installing_sql_clustering_virtual_server2.asp I’m able to setup the cluster, but Virtual Server 2005 only lists two available SCSI adapter id’s, (6 and 7). This allows me to setup the quorum disk, but no other disks. Does anyone know what limits the number of scsi id’s? If it matters, I’m doing this testing on an HP desktop that has a single EIDE drive. I found one post that suggested it was related to the single drive in the physical machine, but the information wasn’t very clear and I wanted to see any anyone had any additional info. Thanks!
What was the hardware used to set this up?
Have you checked as perhttp://msdn2.microsoft.com/en-us/library/ms143506.aspx list. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
I don’t remember the exact model, but the hardware is a newer HP desktop, (3GHz I believe). I’m sure it’s not a certified piece of cluster hardware, but I’m only using this for testing. The issue is really with "Virtual Server 2005" and the fact that it limits me to only two virtual scsi adaptors, so technically this isn’t really a SQL or Clustering related question. I run into this problem while setting up the VM in Virtual Server before I even install the VM’s OS.
I don’t have a current setup to check, but if I remember correctly, I created a total of 4 virtual drives. Two of them were IDE type drives and used for the drive C of each node, then the other two were virtual SCSI drives, one for the quorum drive and the other for the data drive. This way, you only need two SCSI drives to create the virtual cluster. As long as the hardware you run on supports Virtual Server, then you can create a virtual cluster on any hardware. The virtual drives you create have no correspondence to the physical drives in your server. ——————————–
Brad M. McGehee, SQL Server MVP
Hi Brad, Very strange… There must be something wrong with either my harware or how I have virtual server setup. Since I only have two scsi ids, I can only create one shared disk. Node A uses scsi id 7 and node B uses scsi id 6. After that I can’t create additional disks since there are no more available ids. Let me know if you or anyone else has any other thoughts.
Thanks again. Charlie
I installed VMWare server instead and installed my test cluster on 2 VM’s. I found it very easy to install/configure in this env. In case if u wish to explore this: http://www.vmware.com/pdf/server_admin_manual.pdf Thanks