Virtual Server

  • Does anyone know the pros and cons with using Virtual server on a test and reporting environment? We need a test and reporting server for one of our apps and the server guys here are recomending using Virtual server...Thanks!

    Thanks!

  • Pros:  Your server guys will not need to dedicate you a stand alone server.

    Cons: Keep in mind that your Virtual Server will be sharing physical resources with other Virtual Servers.  This means that 1 physical server will be split up into Virtual Servers using some brand of VM ware.  These Virtual Servers will then share CPU, I/O, Memory, and Network bandwidth.  This usually leads to slower performance than a stand alone server (unless, of course, the server used for Virtual servers is a Hoss).  I have found that, for reporting purposes, users expect fast turn around for reports and / or ad-hoc queries.  Using the Virtual Server apporach will, more times than not, make your reporting move slower. 

    Just my 2 cents.....

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • Wrong forum, this is the Notification Services forum.

  • Thanks for the info! Sorry about posting in the wrong place.

    Thanks!

  • Performance also depends on what type of virtual technology you are using. For instance, VMware ESX server has tweaks not available in GSX or in Microsoft's Virtual Server. However, as John indicated, you will never be as fast as if installed directly on the physical server.

    Other pros: Easier for the sysadmins to maintain. Easier to update (VM can be copied in a previous state making rollbacks a snap). Reboots quicker than a physical server. And if you're using VMotion technology on ESX server, you can also gain additional maintenance and reliability helps.

    K. Brian Kelley
    @kbriankelley

  • Here's another recent post with similar info:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=282436

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 6 posts - 1 through 5 (of 5 total)

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