Consolidating databases best practices dating an ibanez bass
In the crusade to cut expenses, Data Centres (and IT Infrastructure) are now coming under scrutiny as a possible source of savings.Half-informed executives now rally behind the cry of "Virtualization! Consolidated our Hyperion and DW dbs into one instance.1(Why): Limited number of lpars on our p-series. Don’t forget to enter a proper email address (remember that it’s not shared) when entering a comment so that I can follow up in case you get the prize. Feel free to share even later but the prize will be gone by then! Alex What does it take to be chief technology officer at a company of technology experts? Highly sought after for his deep expertise and interest in emerging trends, Alex routinely speaks at industry events as a member of the Oak Table.An underutilized SQL Server can result in increased hardware and management costs, lack of standardization and other challenges associated with business continuity.Fortunately, by using SQL Server 2008 on Windows Server 2008, organizations can successfully address the issues associated with underutilization by consolidating SQL Server instances and databases onto fewer physical or virtual servers.
For example, SQL Server instances and databases using less than 30% of their hardware's processor, memory and disk space are excellent candidates for consolidation.Dear blog readers, I’m working on a small story about database consolidation and interested to learn what are success and failures that others are going through. Consolidating means the backup window is shared, the redo archiving and recovery in DR can be simplified and processes can be merged.While we have our own experience at Pythian, I find it interesting to learn about what others are going through. What were expectations / success criteria and how they were set? And we do not have the infra-structure to run these as multiple RAC instances, which would be the other option.2(Expectations and success criteria): Ensure that Hyperion processing would not be affected by DW processing other than in memory and CPU resources, which can be easily apportioned if needed using execution profiles.This article will look at some of the business concerns driving server consolidation efforts, as well as some of the decision factors you should consider when thinking about what your future environment will look like.I’ve also included a sample process flow to help you understand and plan your own server consolidation project, so you should have everything you need.