Is Microsoft SQL 2008 has any issue with VM 5.1?

Posted on 2012-09-09
Last Modified: 2012-09-13
Hello there,

I have MS SQL 2008 servers as VM running on version VM vsphere 4.1.

VM Admin is in the process of upgrading his from 4.1 to new 5.1. Will there be any issue for my SQL 2008 servers?

Is thers any doco or white paper suggesting that it is MS SQL 2008 is compatible with VM 5.1.

Please advise.

Thanks and Regards
Question by:goprasad
    LVL 116

    Expert Comment

    by:Andrew Hancock (VMware vExpert / EE MVE)
    Bookmark this VMware Product Interoperability Matrixes

    VMware vSphere 5.1 is scheduled for released later this week, when documents and upgrade guides will be available. The above guide will list exactly what is supported when updated.

    VMware vSphere 5.1 requirements are similar to VMware vSphere 5.0.

    vSphere Installation and Setup Guide
    LVL 116

    Accepted Solution

    No Issues. See below.

    New Whitepaper today, on High Performance Testing SQL with VMware vSphere 5.1, tests were conducted on Microsoft SQL 2008.

    See here

    if you look at the Appendix

    Appendix: Test Bed Configuration
    The lab environment used the following at-scale inventory, where the vCenter Server inventory was at or near the configuration maximums for most items on the list:

    1,000 hosts
    10,000 powered on VMs
    15,000 registered VMs
    32 clusters
    2,000 datastores

    Virtual machine running vCenter Server:

    16 vCPUs
    52GB memory

    Virtual machine running database (Microsoft SQL Server 2008):

    16 vCPUs
    26 GB memory

    Database files: RAID-5 storage backed up by 10 disks. Each disk is 2Gbps, 5200rpm, 133.68GB

    Log files and tempdb: 10 disks RAID-5 storage. Each disk is 2Gbps, 5200rpm, 133.68GB

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    This is similar to the error described in my previous Article, but with a different source problem and a different solution. When trying to scan and stage the ESXi 6.0 updates using VMware Update Manager, we can get "error code 90"
    David Varnum recently wrote up his impressions of PRTG, based on a presentation by my colleague Christian at Tech Field Day at VMworld in Barcelona. Thanks David, for your detailed and honest evaluation!
    Teach the user how to rename, unmount, delete and upgrade VMFS datastores. Open vSphere Web Client: Rename VMFS and NFS datastores: Upgrade VMFS-3 volume to VMFS-5: Unmount VMFS datastore: Delete a VMFS datastore:
    Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now