Consolidating sql servers best practices

13-Feb-2018 09:29 by 6 Comments

Consolidating sql servers best practices - 3d sex chat bots

SQL Server consolidation is being driven by the need to reduce cost in over a third of cases — 34% — followed by a drive to improve efficiencies at 25% and a need to standardize at 21%.IT agility also plays a small but significant role in driving consolidation, stated by 10% of the sample as the key business driver.

If license savings is the core driver of your consolidation project, be sure to understand this impact.

Here are some of the key challenges that, if not properly addressed, may take the shine off your consolidation efforts.

By consolidating multiple SQL Server databases onto a single SQL Server the CAL requirement may increase.

This is consistent in what we see in the field and marketplace; cost efficiency and new features enabling better performance, availability and management are driving our clients in the same direction.

SQL Server consolidation involves analyzing the servers in your enterprise and grouping databases onto a smaller number of servers without compromising the performance of any applications using SQL resources.

These types of databases are isolated from other databases and are not candidates for SQL Server consolidation.

There are factors IT should be aware of when consolidating SQL Server instances and databases on fewer systems.

Gridstore recently conducted a survey of over 125 Enterprise IT professionals a number of detailed questions surrounding the issue of SQL Server consolidation, including the business challenges driving their changes.

While cost reduction was the #1 response to what is driving the desire for SQL consolidation, this was tempered by the top three issues concerning respondents when it came to consolidation — Performance (74%), High Availability (51%) and Manageability (40%).

As you decommission SQL Servers you may be able to cannibalize some of these CALs, but you will probably have to upgrade to a per-processor license.

Consolidating also typically requires increased hardware resources.

Fortunately, with proper planning, training and by understanding the potential roadblocks of SQL Server consolidations, organizations can still reduce the total cost of ownership associated with managing and operating their SQL Server infrastructures.