Countless companies want to take advantage of Microsoft SQL Server 2005 and its notable business and technology benefits. However, with the prevalence of large, complex and sprawling information technology (IT) infrastructures, many organizations are wary of - or avoid altogether - the time, expense and effort required for a mass overhaul of their database environment.
The success of SQL Server in recent years has produced a phenomenon of SQL Server sprawl - the uncoordinated deployment of tens, hundreds or even thousands of database servers. The result has been low levels of utilization, poor availability and, most importantly, an enormous management burden inflicted on many IT departments. There is an acute need for a way to deploy SQL Server that allows capacity to be matched appropriately to need, that provides high availability without introducing extra complexity and extra cost, and that actually simplifies the life of administrators.
This paper outlines a ready-made solution that delivers comprehensive infrastructure optimization in accordance with Microsoft’s APO model. Using HP PolyServe software in conjunction with HP BladeSystem c-Class products and Microsoft SQL Server Enterprise Edition, organizations can attain Dynamic Infrastructure capabilities while reducing server counts by 50%, decreasing configuration and management time by up to 75%, and providing high availability to all servers and SQL Server-based applications.
Microsoft SQL Server has enjoyed phenomenal success as a database server. Its relatively low cost, steadily increasing capabilities and ease of deployment have all combined to accelerate its growth. However, that same growth has led to a phenomenon commonly called SQL Server “sprawl”— the rampant, often uncontrolled, proliferation of SQL Server databases.