The Ideal SQL Server Virtual Machine Architecture - Level 2 of the Stairway to SQL Server Virtualization

  • David Klee

    SSC Veteran

    Points: 258

    Comments posted to this topic are about the item The Ideal SQL Server Virtual Machine Architecture - Level 2 of the Stairway to SQL Server Virtualization

  • jan.paija

    SSC Veteran

    Points: 207

    Nice series, thank you!

    Just learned about vNUMA at a customer that finally bumped up the memory for a SQL Server to 150GB to be able to handle the load. Looked a bit funny i task manager with 3 NUMA nodes, but I learned that Hyper-V automatically split the configuration, placing two of the eight vCPU on to the other pNUMA.

    Now they SQL Server runs on 2 x 3 vCPU in two vNUMA and 1 x 2 vCPU in the third vNUMA.

    The physical server has 2 CPU 8 cores, HT enabled (so 32 cores total), 196GB RAM total.

    Is this config OK, or should we consider something different with the NUMA config? There are some other VMs running on the host as well.

    Will you cover VMQ and SR-IOV in the next article? Sounds like really interesting options, but are they hard to implement and get working as expected? The H/W is supposed to support it according to the documentation.

    Best regards

    / Jan

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the info. I'll be passing this on to our admin.

  • rachilles

    SSC Journeyman

    Points: 87

    Great article, and very timely for me.

    In the Virtual Disk presentation illustrations, it shows a disk cylinder with OS, Data and Logs all in one cylinder, seemingly attached to one LUN.

    In researching system optimization, I've come to believe that we need to distribute each of these on their own LUN (along with TempDB, paging, and file groups.)

    The next graphic showing the bottleneck scenarios shows the distributed file groups attaching to a few LUNs, though not specifically to their own LUN.

    Is my general belief flawed? Is the deeper concern just to ensure that the Data, Logs, tempDB, etc. are transiting via separate HBAs? Should this happen automatically if they all live on their own separate virtual drives (vmdks)? Or is it good enough to have each virtual drive attach to individual data stores that reside on one LUN?

    Thanks again for a great treatment of a complex topic!

  • MiguelSQL

    Hall of Fame

    Points: 3079

    rachilles (5/13/2015)


    Great article, and very timely for me.

    In the Virtual Disk presentation illustrations, it shows a disk cylinder with OS, Data and Logs all in one cylinder, seemingly attached to one LUN.

    In researching system optimization, I've come to believe that we need to distribute each of these on their own LUN (along with TempDB, paging, and file groups.)

    The next graphic showing the bottleneck scenarios shows the distributed file groups attaching to a few LUNs, though not specifically to their own LUN.

    Is my general belief flawed? Is the deeper concern just to ensure that the Data, Logs, tempDB, etc. are transiting via separate HBAs? Should this happen automatically if they all live on their own separate virtual drives (vmdks)? Or is it good enough to have each virtual drive attach to individual data stores that reside on one LUN?

    Thanks again for a great treatment of a complex topic!

    Thank you for the series.

    This too is a very complicated topic for me to understand and I keep seeing conflicting information about distributing your files among many drives.

    If the VMDK are in the same LUN... do I have any performance gain by using many disk?

    What about the HBA? Does each VMDK need to have its own HBA and its own LUN?

    and lastly... from within the VM host... how can I tell how the disks were provisioned without having to hunt down a VM Admin?

    Any links would be appreciated.

    Great series!

    Miguel

  • Jim_K

    SSCrazy

    Points: 2303

    One question, in the vNUMA Scalability example what was the underlying hardware? Was it a 4 socket host? The article seems to indicate that it is, but I'm not sure and my morning coffee hasn't kicked in. 😀

  • Paulo A. Nascimento

    SSCommitted

    Points: 1571

    Hi David,

    Do you think it's really a good idea to have both data (primary and secondary data files) and transaction logs of tempdb in the same disk/drive letter/volume ?

    Cheers,

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Still a good read even a year later.

  • quackhandle1975

    SSChampion

    Points: 10963

    Thanks David, great article.

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply