SQL Server Performance

To Virtualize or Not

Discussion in 'EditorsBlog' started by shanetasker, Jan 15, 2009.

  1. shanetasker New Member

    There are a number of debates in IT that people are very passionate and one sided about. When you talk about SQL Server one of the perennial debates surrounds the capitalisation of keywords in TSQL scripts. Although this debate has far from disappeared, it seems to be overshadowed by the current debate of whether to virtualize SQL Server or not. There are those that refuse point blank to virtualize and then those on the other side of the fence, with very little middle ground.
    I think virtualisation is like any other server installation—it can be done right or it can be done wrong. The problem is that when it goes wrong performance is often severely affected. One of the biggest problems with virtualization I see is that the decision to virtualize is based on the key driver of consolidation. As a result, people try to maximise their investment by squeezing too many server instances into the hardware footprint. Just like any sever install, if the hardware is not sized or configured appropriately, performance will decrease as a result. So on which side of the fence do you sit in the Virtualisation Debate?
    - Peter Ward

Share This Page