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%).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.it can be defined simply as reduce the number of physical SQL servers, by migrating/moving different SQL databases running on different servers into one high performance server machine.Early in the process of a consolidation project, you will create a profile to help identify which applications are good candidates for consolidation.For any SQL Server Performance Tuning Issue send email at [email protected] is also a Cross Fit Level 1 Trainer (CF-L1) and Cross Fit Level 2 Trainer (CF-L2).
Database migrations are necessary when consolidating SQL Server instances and databases onto fewer hosts.
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.
Then you can identify the applications that fit this profile.
Some general traits that make an application a good candidate for consolidation are: Each of these strategies has different advantages and disadvantages related to security and compliance requirements, high availability and disaster recovery requirements, resource management benefits, level of consolidation density, and manageability tradeoffs Consolidation projects are typically started to achieve specific goals such as creating room for new servers or reducing operating expenditure.