[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Is Microsoft SQL 2008 has any issue with VM 5.1?

Posted on 2012-09-09
2
Medium Priority
?
672 Views
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
0
Comment
Question by:goprasad
  • 2
2 Comments
 
LVL 124
ID: 38381522
Bookmark this VMware Product Interoperability Matrixes

http://partnerweb.vmware.com/comp_guide2/sim/interop_matrix.php

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
0
 
LVL 124

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 2000 total points
ID: 38383413
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

http://www.vmware.com/files/pdf/techpaper/VMware-vCenter-DBPerfBestPractices.pdf

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
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If we need to check who deleted a Virtual Machine from our vCenter. Looking this task in logs can be painful and spend lot of time, so the best way to check this is in the vCenter DB. Just connect to vCenter DB(default DB should be VCDB and using…
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…
In this video tutorial I show you the main steps to install and configure  a VMware ESXi6.0 server. The video has my comments as text on the screen and you can pause anytime when needed. Hope this will be helpful. Verify that your hardware and BIO…
Suggested Courses

834 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