Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Virtual Server Technologies and SQL Server


By:   |   Last Updated: 2007-02-21   |   Comments   |   Related Tips: More > Virtualization

Problem
Recently virtual server technologies have been getting a great deal of buzz in the industry.  Is this a technology that I should have on my radar screen?  What impacts does this technology have on SQL Server?  What can virtual SQL Servers do for me as a DBA?  I have been hearing a great deal of positive information, but is there any down side of implementing this technology for SQL Server?  Where can I find more information on virtual server technologies? 

Solution
Virtual server technology has been available for the last few years and has grown in popularity for a number of reasons.  As a DBA, it should be a technology that you have on your radar screen because it can probably help you in specific areas. 

What are some of the benefits associated with the virtual servers?

  • Consolidate many small machines to a single host with many virtual servers that still has the original server name, IP address, etc.
  • Ability to create new SQL Servers quickly and in a consistent manner.
  • Ability to shut down and move around the virtual servers on the host as needed (virtual server product dependent).
  • Ability to have a number of development and test instances that can be easily created and removed based on the testing needs.
  • Ability to perform load testing with resources similar to the production environment by reallocating the resources to the virtual server during the testing session and then allocate the resources to the original virtual servers.
  • Ability to leverage this technology for disaster recovery purposes.

Do you have any words of caution?

  • Capacity Planning - Perform capacity planning to ensure the host will support the virtual servers for a specific period of time (6, 9, 12, etc. months) do not assume that the host will just support all of the virtual servers.
  • IO Issues - Systems that are currently IO bound should have the IO issues addressed prior to building a virtual server.  Do not assume\expect that these IO issues will disappear with the virtual server.
  • Host Updates - If an update (service pack, hot fix, etc.) is needed for the host, the virtual servers may need to be shutdown when the update is installed.  Verify with the virtual server vendor.
  • Licensing Costs - Using virtual server technology may not eliminate licensing costs.  Check with your vendors.
  • Hardware Costs - Using virtual server technology may not reduce the hardware costs or monthly lease expenses.  Check with your vendors
  • SQL Server Consolidation - Although all of the virtual server instances are on the same physical piece of hardware, which is good for the networking folks, as a DBA we typically manage the SQL Server instance.  As such, do not cause a situation where you are going to have to manage more instances of SQL Server with the virtual server technology.  Shoot for a situation where you are managing the same number of instances or less.

As a DBA should I consider any alternatives to virtual server technologies?

  • Multiple SQL Server Instances - One option is to build a number of SQL Server instances on a single SQL Server, but if Windows related applications need to run outside of SQL Server, version control for development and test may be time consuming, so a virtual server may be easier in the long term
  • Databases Consolidation to a Single SQL Server Instance - Consolidating multiple SQL Server instances to a single SQL Server instance may be great from a DBA perspective, but the front end application will need to be changed to support the new connection string at a minimum.  In addition, keep an eye on security, file shares and SQL Server Jobs to see what types of impacts they will have on the consolidation process.
  • Dedicated Physical Servers - Continuing down the path of dedicated SQL Servers can be costly from a power, rack space and operations management perspective, but could be necessary based on security, performance and charge back type situations.

Who is using VM's?

  • Many organizations of all sizes and industries have adopted virtual server technologies for development, test and production SQL Servers from a variety of virtual server vendors.
  • Many ISP's have adopted the technology to support instances of Windows server for web sites or dedicated applications.

Who are some of the virtual server vendors?

Next Steps



Last Updated: 2007-02-21


get scripts

next tip button



About the author
MSSQLTips author Jeremy Kadlec Since 2002, Jeremy Kadlec has delivered value to the global SQL Server community as an MSSQLTips.com co-founder and Edgewood Solutions SQL Server Consultant.

View all my tips
Related Resources




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools