APAC CIOOutlook

Advertise

with us

  • Technologies
      • Artificial Intelligence
      • Big Data
      • Blockchain
      • Cloud
      • Digital Transformation
      • Internet of Things
      • Low Code No Code
      • MarTech
      • Mobile Application
      • Security
      • Software Testing
      • Wireless
  • Industries
      • E-Commerce
      • Education
      • Logistics
      • Retail
      • Supply Chain
      • Travel and Hospitality
  • Platforms
      • Microsoft
      • Salesforce
      • SAP
  • Solutions
      • Business Intelligence
      • Cognitive
      • Contact Center
      • CRM
      • Cyber Security
      • Data Center
      • Gamification
      • Procurement
      • Smart City
      • Workflow
  • Home
  • CXO Insights
  • CIO Views
  • Vendors
  • News
  • Conferences
  • Whitepapers
  • Newsletter
  • Awards
Apac
  • Artificial Intelligence

    Big Data

    Blockchain

    Cloud

    Digital Transformation

    Internet of Things

    Low Code No Code

    MarTech

    Mobile Application

    Security

    Software Testing

    Wireless

  • E-Commerce

    Education

    Logistics

    Retail

    Supply Chain

    Travel and Hospitality

  • Microsoft

    Salesforce

    SAP

  • Business Intelligence

    Cognitive

    Contact Center

    CRM

    Cyber Security

    Data Center

    Gamification

    Procurement

    Smart City

    Workflow

Menu
    • Database
    • Cyber Security
    • Hotel Management
    • Workflow
    • E-Commerce
    • Business Intelligence
    • MORE
    #

    Apac CIOOutlook Weekly Brief

    ×

    Be first to read the latest tech news, Industry Leader's Insights, and CIO interviews of medium and large enterprises exclusively from Apac CIOOutlook

    Subscribe

    loading

    THANK YOU FOR SUBSCRIBING

    • Home
    Editor's Pick (1 - 4 of 8)
    left
    Analytics Every where -The Power of Insight in the Digital World

    Adam Howatson, Chief Marketing Officer, OpenText

    It's Time to Seize Control of your Data!

    Chris Lin,

    Dialing Down-How Small Data Leads to Big Processes

    Marc Perlman, Global VP Healthcare and Life Sciences, Oracle Healthcare

    Structured Data Remains Focal Point Despite Rapidly Changing Information Management Landscape

    John Whittaker, Executive Director, Marketing, Information Management, Dell Software

    Integrating New Database Technological Innovations

    Hesom Parhizkar, Vice President - Technology & Operations, eVestment

    Connecting the Dots between Compliance and Data for Surplus Assets and Inventory

    Jill M. Williamson, Compliance Officer, Liquidity Services

    How To Conduct Customer Management when doing Database Support

    SujainThomas, Data IT professional, remotedba.com

    Private Cloud Database as a Service-How to Deliver Data Management Agility and Choice that Rivals the Public Cloud

    Ken Rugg, Founder, CEO and Board Member, Tesora

    right

    Are Your Database Administrators Against Virtualizing Your SQL Servers?

    Chris Shaw, Sr.Database Engineer, Xtivia

    Tweet
    content-image

    Chris Shaw, Sr.Database Engineer, Xtivia

    If you answered yes, this doesn’t surprise me. For years, I was against placing any instance of SQL Server, especially a mission critical one, anywhere near a virtualized environment. The Internet was scattered with assorted horror stories about how virtualizing SQL Server would lead to a resume-changing event. As a Database Administrator, I recall the pains of my first SAN Migration. During this migration one of the major changes was the visibility into the underlining architecture. Essentially, we lost that visibility. This means that we couldn’t fix what we couldn’t see. This is the same type of environmental change database administrators go through when moving to a virtual environment.

    Even stubborn Database Administrators are unable to refute the cost benefits of a virtualized environment; business needs are going to drive technology and the surrounding decisions for many years to come. Software companies are motivated to provide these solutions simply because of the business need to provide better infrastructure for less money. This action leads us to the real question, what information needs to be supplied to the Database Administrator so they are comfortable with virtualizing SQL Server?

    Database Administrators often make a number of configuration changes to optimize the way SQL Server utilizes the hardware. For example, Database Administrators make adjustments to how much memory SQL Server can use. The goal is to leave the operating system enough memory while simultaneously giving SQL Server enough memory for efficient query processing. In a virtualized environment, Database Administrators still need to know how to tune the configuration to meet the demanding performance requirements of mission critical databases. Virtualization adds another layer of complexity that the Database Administrator now has to take into account.

    Microsoft SQL Server memory usage can be tuned by adjusting the minimum memory and maximum memory. When adjusting the maximum server memory it is common to set allocation of memory for

    SQL Server at a very aggressive level thus leaving the Operating System starved for memory. This is an easy mistake to make, considering that many SQL Servers are dedicated to running only SQL Server. However, processes as simple as copying backup files off the server can impact the memory usage on the operating system. If the operating system is starved for memory, the downstream effects will be materialized in SQL Server. Limiting the maximum memory within SQL Server will often improve the overall performance as well as alleviate the memory starvation of the operating system. The minimum memory setting is frequently left untouched, at the default setting. This allows for Microsoft SQL Server to release memory back to the operating system when Microsoft SQL Server has finished with it. It is not common to see the minimum memory setting configured, I suspect this is because most Database Administrators understand how important the memory can be, when it comes to high performing Microsoft SQL Servers. To finish the memory configuration for virtualized servers, enable the ‘Lock Pages in Memory’ for the account that the SQL Server service is running as.

    “Most Database Administrators are going to need to see proof that moving to a virtualized environment is not going to impact the mission critical environment negatively”

    VMWare put a considerable amount of research into a SQL Server configuration, which produces optimal performance on VMware platforms. Some of these recommendations go against the traditional configuration of SQL Server, such as the minimum memory setting.

    Memory isn’t the only hardware consideration when it comes to finding support from your Database Administrators. There is always the issue of storage and how important it is to the performance of the database. When Database Administrators request storage from SAN Administrators often the only question we are asked is, “What is the size of the volume?”Seasoned Database Administrators should reply with the amount of storage, and follow up that request with a specific latency the database will require (Microsoft recommends sub five millisecond for log files and sub 10 millisecond for data files). In a virtualized environment the requirement doesn’t change. The SQLIO tool by Microsoft works just as well in a virtualized environment just as it does physical environments.

    Technical articles and White Papers can only go so far when it comes to winning over your Database Administrators to using virtualized environments. Most Database Administrators are going to need to see proof that moving to a virtualized environment is not going to impact the mission critical environment negatively. In the physical world, when new architecture was being considered this often meant the commitment of the organization to purchase test machines. In a virtualized environment a new test machine can be spun up within a matter of minutes. Using this virtual test machine, the Database Administrator can perform benchmark testing to determine the overall impact. When the results of these tests are placed side by side, with the flexibility that a virtualized environment offers as well as the overall savings, then the decision to support a virtualized environment is pretty clear. As a Database Administrator, I am very cautious when trying a new technology because the stability of business critical applications are depending on me. However, when the technology is easily tested and has been well documented, my comfort level increases. Today, at XTIVIA 60-70 percent of the SQL Server installations weper  form are in a virtualized environment, with the majority of those being installed on VMWare.

    Weekly Brief

    loading
    ON THE DECK

    I agree We use cookies on this website to enhance your user experience. By clicking any link on this page you are giving your consent for us to set cookies. More info

    Copyright © 2025 APAC CIOOutlook. All rights reserved. Registration on or use of this site constitutes acceptance of our Terms of Use and Privacy and Anti Spam Policy 

    Home |  CXO Insights |   Whitepapers |   Subscribe |   Conferences |   Sitemaps |   About us |   Advertise with us |   Editorial Policy |   Feedback Policy |  

    follow on linkedinfollow on twitter follow on rss
    This content is copyright protected

    However, if you would like to share the information in this article, you may use the link below:

    https://database.apacciooutlook.com/cxoinsights/are-your-database-administrators-against-virtualizing-your-sql-servers-nwid-1470.html