SQL Server and Virtualization Hyper-V 2012 vs VMWare ESXi 5.5

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MartyC123
    New Member
    • May 2014
    • 2

    SQL Server and Virtualization Hyper-V 2012 vs VMWare ESXi 5.5

    Hi, I have a situation where the customer wants to virtualize all their SQL Servers. They have medium sized databases and are a smaller company. The problem is the customer does not know which virtualization tool to use. I am not an expert on virtualization, and they are having someone else set up the servers. I started to think, how negatively this could effect me, if the SQL Servers don't perform well.

    I would think that a microsoft product would run better on a microsoft product and support would be better, but most of their storage was setup by EMC, and they use mostly EMC products for their storage/backup etc. so the hardware guys want to go with VMWare and it might be a better tool for most apps, but I still have a reservation on how SQL Server will work. I already see some serious clustering limitations such as no shared storage. They also want to implement Always On Replicas.

    I am wondering if anyone already had to do this exercise and what experiences they had. A good unbiased opinion would be very much appreciated. Thanks.
  • Luk3r
    Contributor
    • Jan 2014
    • 300

    #2
    The company I work for actually converted physical servers to vmdk's and ran them as Virtual Machines on VMWare... that's a HORRIBLE idea. One for imaging (close to 3TB of data) and one for user data (around 1TB). But if the server is going to be a fresh build with SQL, you won't regret it. We eventually rebuilt out servers but used the old databases and couldn't be any more happy. Just make sure that if you go VMWare to follow the VMWare best practices manual and everyone will be happy.

    Comment

    • MartyC123
      New Member
      • May 2014
      • 2

      #3
      Thanks Luk3r. One question. How does your clustering work, they want to do a 2 coast stretch cluster. I am not sure how that works in VMWare. So One SQL CLuster on the east coast with an Always On HA solution sitting on a Windows Failover Cluster, and if that goes down then it should flip to the west coast. Do you do anything like that for DR?

      Comment

      • Luk3r
        Contributor
        • Jan 2014
        • 300

        #4
        We're a pretty small sized business. 150~ users. We do have a remote site but there are no servers there. We do have HA setup within the VMWare cluster and it works fantastically for DR purposes. I'm not sure how it'd perform across sites, though.

        Comment

        Working...