none
using virtual machine for sql server

    Question

  • We have a SharePoint 2010 server farm already setup which uses VMware for back end SQL server 2008 r2. Anyone can tell me what's the drawback of this implementation? What are the cons?

    Thanks in advance,



    • Edited by peterxw Tuesday, April 10, 2012 2:14 AM
    Tuesday, April 10, 2012 2:13 AM

Answers

  • The main drawback you will see is performance.  It really just depends on the size of your environment.  People do it all the time though, but you can definitely get better performance with proper drive configuration on dedicated hardware.

    Corey Roth - SharePoint Server MVP blog: www.dotnetmafia.com twitter: @coreyroth

    • Proposed as answer by Paul Turner _ Tuesday, April 10, 2012 7:40 AM
    • Marked as answer by peterxw Tuesday, April 10, 2012 1:44 PM
    Tuesday, April 10, 2012 3:23 AM
  • In most cases, a physical server will perform better than a virtual. A virtualized SQL server is OK for a small farm. Medium to large farms should really assess their environment before choosing between virtual and physical.

    Please read the following on SP virtual architectures.

    http://technet.microsoft.com/en-us/library/ff607811.aspx

    • Marked as answer by peterxw Tuesday, April 10, 2012 1:45 PM
    Tuesday, April 10, 2012 4:38 AM
  • Hi Peter xw. You'll get one more answer...

    The only real drawback, is possibly lessened performance. But if you do not see any issues with performance, then go ahead. Using a virtual SQL in the backend is very common today and is fully supported by Microsoft. It's like all things SharePoint: 'It depends...'

    If you have acceptable performance today or it is a smaller environment, then keep doing what you do, it could also be that a well configured VM ware environment performs better than a badly configured physical server. It all depends...

    If you can live with the cons, then go ahead and enjoy the andvantages, because they are plenty and good. The disaster/revovery benefits are huge as well as backup and cloning functions not available as easily to a physical environment.

    Hope that helps a bit

    Regards


    Thomas Balkeståhl - Technical Specialist - SharePoint - http://blog.blksthl.com
    Download the SharePoint Branding Project here

    • Proposed as answer by Paul Turner _ Tuesday, April 10, 2012 7:39 AM
    • Marked as answer by peterxw Tuesday, April 10, 2012 1:44 PM
    Tuesday, April 10, 2012 4:53 AM

All replies

  • The main drawback you will see is performance.  It really just depends on the size of your environment.  People do it all the time though, but you can definitely get better performance with proper drive configuration on dedicated hardware.

    Corey Roth - SharePoint Server MVP blog: www.dotnetmafia.com twitter: @coreyroth

    • Proposed as answer by Paul Turner _ Tuesday, April 10, 2012 7:40 AM
    • Marked as answer by peterxw Tuesday, April 10, 2012 1:44 PM
    Tuesday, April 10, 2012 3:23 AM
  • I thinks it non things to effect.. it depending on you organization requirement and make sure your hardware capacity are ok.

    • Edited by Tola Dy Tuesday, April 10, 2012 4:26 AM
    Tuesday, April 10, 2012 4:24 AM
  • The Reference Paper says 

    with some interesting benchmarks (limited test using Xen and PostgreSQL only). The conclusion was that using a VM does "not come at a high cost in performance"

    http://www.cs.uwaterloo.ca/~ashraf/pubs/smdb08overhead.pdf

    Another reference links says about the advantages,disadvatages and best practise when using SQL SERVER in a Virtualization environment : http://blogs.msdn.com/b/john_daskalakis/archive/2010/02/01/9956270.aspx

    Hope this will help you.

    Regards

    Senthil.S

    Tuesday, April 10, 2012 4:38 AM
  • In most cases, a physical server will perform better than a virtual. A virtualized SQL server is OK for a small farm. Medium to large farms should really assess their environment before choosing between virtual and physical.

    Please read the following on SP virtual architectures.

    http://technet.microsoft.com/en-us/library/ff607811.aspx

    • Marked as answer by peterxw Tuesday, April 10, 2012 1:45 PM
    Tuesday, April 10, 2012 4:38 AM
  • Hi Peter xw. You'll get one more answer...

    The only real drawback, is possibly lessened performance. But if you do not see any issues with performance, then go ahead. Using a virtual SQL in the backend is very common today and is fully supported by Microsoft. It's like all things SharePoint: 'It depends...'

    If you have acceptable performance today or it is a smaller environment, then keep doing what you do, it could also be that a well configured VM ware environment performs better than a badly configured physical server. It all depends...

    If you can live with the cons, then go ahead and enjoy the andvantages, because they are plenty and good. The disaster/revovery benefits are huge as well as backup and cloning functions not available as easily to a physical environment.

    Hope that helps a bit

    Regards


    Thomas Balkeståhl - Technical Specialist - SharePoint - http://blog.blksthl.com
    Download the SharePoint Branding Project here

    • Proposed as answer by Paul Turner _ Tuesday, April 10, 2012 7:39 AM
    • Marked as answer by peterxw Tuesday, April 10, 2012 1:44 PM
    Tuesday, April 10, 2012 4:53 AM