SQL Server Performance

Virtual Server 2005 - SCSI Adapter Question

Discussion in 'SQL Server 2005 Clustering' started by cpyne, May 10, 2007.

  1. cpyne New Member

    Hi,

    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!
    Charlie
  2. satya Moderator

  3. cpyne New Member

    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.

  4. bradmcgehee New Member

    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
    http://www.sqlbrad.com
  5. cpyne New Member

    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
  6. gujsa01 New Member

Share This Page