Consolidating databases sql server Datingfree og

The plummeting cost and increased power of today's server components has moved the real cost of modern computing from hardware to people, processes, power and space.

As such, in a never ending quest to minimize operating costs, businesses have embraced consolidation and virtualization techniques, the major goals of which are to avoid server sprawl and minimize costs. Given the ease with which new SQL Server installations can be deployed, and the power of today's commodity PCs, SQL Server sprawl is an all too common problem.

Consolidating and optimizing your servers will go a long way toward reducing the cost and complexity of your database environment.

This brief is the first in a series of articles on optimizing SQL Server environments, describing the initial steps to take toward consolidation.

The number of databases using MS SQL Server has exploded since its launch of version 2005 .

consolidating databases sql server-84consolidating databases sql server-55

The arrival of personal computer networks marked a shift away from big iron mainframes and dumb terminals to a decentralized processing model comprised of many (relatively cheap) servers and lots of personal computers.

When the number of Enterprise SQL Servers begins to grow along with your business, it is often difficult to keep up.

A lack of coordination or database expertise can exacerbate problems associated with this growth.

This is not about virtualisation of database servers.

This is about the steps you should take before you consider if and how best to virtualise servers.