SQL Server Sprawl Guidance

Is your IT department a victim of “SQL Server Sprawl” The term refers to the large numbers of SQL Server installations in an enterprise? Many applications require a database to house information. It is not common that applications are often rolled out with their own instance of SQL. As databases are an unavoidable part of an Infrastructure, organizations find it increasingly difficult to manage these databases effectively. This difficulty results in greater management costs, underused servers, increased power and cooling requirements, and reduced security.

Why should you consider consolidation of SQL Databases?
What is the ROI?
How can we guarantee performance?

All excellent questions..the answer “Reference Architecture”. HP and Dell have partnered with Microsoft to provide an all software, hardware, and services complete solution to tackle SQL Server Sprawl.

Consolidation projects are typically started to achieve precise goals such as creating room for new servers or reducing operating expenditure. These goals can be broadly grouped into the following categories:

  • Lack of space in the data center
  • Reducing costs and improving efficiency
  • Standardization and centralization
  • IT agility
  • Green IT

“Consolidation, in general terms, is the combining of various units into more efficient and stable larger units. When applied to an IT department, consolidation specifically translates into improved cost efficiency from higher utilization of resources, standardization and improved manageability of the IT environment, and (more recently) a focus on a “green” IT environment through reduced energy consumption. One of the important components in the IT environment is the database. Databases tend to be very widespread across the enterprise, because they are very efficient for handling relational storage of data and are designed to be platforms for a wide variety of applications. Because databases form the foundation of so many business systems, IT departments can easily lose control of the number of databases that need to be maintained, because each group may simply create their own database to solve a specific problem they may be experiencing. This leads to a proliferation of databases and machines running database instances also known as database sprawl. Thus databases are one of the prime candidates for consolidation. When consolidating database applications, consider the following three potential strategies: using a single physical machine to host multiple virtual machines (VMs) running Microsoft® SQL Server® data management software, using a single machine to host multiple SQL Server instances, and using a single instance of SQL Server to host multiple databases. Each of these strategies has different advantages and disadvantages related to security and compliance requirements, high availability and disaster recovery requirements, resource management benefits, level of consolidation density, and manageability tradeoffs.”

So why choose an appliance versus an “In House” deployment. They have been built to improve database management, reverse SQL Server sprawl, increase business agility, and reduce total cost of ownership (TCO). They are optimized for SQL Server, they are pre-configured and pre-tuned by the experts at Microsoft, Dell and HP. The appliances are complete solutions that are simple to acquire and deploy, high performing, highly secure and energy efficient. By deploying an appliance instead of building a solution, businesses reduce investment, drastically accelerate time to value, and enable IT resources to focus on other priorities.

Check out the HP Enterprise Database Consolidation Appliance Video