SQL SERVER – White Papers – Consolidation Guidance for SQL Server – Consolidation Using SQL Server 2008

Consolidation Using SQL Server 2008
Writer: Allan Hirt, Megahirtz LLC (allan@sqlha.com)
Technical Reviewers: Lindsey Allen, Madhan Arumugam, Ben DeBow, Sung Hsueh, Rebecca Laszlo, Claude Lorenson, Prem Mehra, Mark Pohto, Sambit Samal, and Buck Woody
Published: October 2009

What are the considerations when creating a consolidation plan for my environment?
What are the key differentiators among the three consolidation options?
How can I use these differentiators to choose the appropriate consolidation option for my environment?

Read Consolidation Guidance for SQL Server

Many companies are considering or have already implemented consolidation of computing resources, including Microsoft SQL Server instances and databases, in their organization. A consolidation effort is a complex task that requires information, a detailed plan and timeline for success, and a strategy for administering the consolidated environment. This white paper walks through the journey of gathering and analyzing the information to base all planning and implementation decisions on; how to plan, architect, and implement consolidation; and finally, the considerations for administering a consolidated SQL Server environment.

Read Consolidation Using SQL Server 2008

Abstract courtesy : Microsoft

Reference: Pinal Dave (https://blog.sqlauthority.com)

Database, SQL White Papers
Previous Post
SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore
Next Post
SQL Server – White Paper – An Introduction to Fast Track Data Warehouse Architectures by Erik Veerman

Related Posts

2 Comments. Leave new

  • Jeremy Huppatz
    December 6, 2009 7:57 am

    Hi Pinal,

    It might be worth mentioning products like the Polyserve SQL Server Utility from HP. It addresses a number of vectors in the virtualization/consolidation question which allows you to achieve:
    * Physical Server consolidation
    * High Availability/Rapid Failover
    * Dynamic Workload Management
    * Connection Virtualization
    * Streamlined Patch Management
    * Clustering outcomes on heterogeneous server hardware
    All this happens while your SQL Server data-server processes are still running against bare metal. That’s a pretty powerful outcome.

    There may be other products that also occupy this space (I think Platespin has a similar offering) but the HP product is backed by a top-tier multinational IT products & services company, and is fully endorsed by Microsoft.

    I should declare here that I’m an HP employee, but I was looking into Polyserve well before EDS (my former employer) and Polyserve were acquired by HP.


    Jeremy Huppatz

  • Hi,

    Any idea on saving multilangual characters in one column within table of SQL2005 database ?




Leave a Reply