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)
2 Comments. Leave new
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.
Cheers
Jeremy Huppatz
Hi,
Any idea on saving multilangual characters in one column within table of SQL2005 database ?
Appreciated.
Hemal