Problems consolidating databases

By Consolidated Database Replay - Workload captured on different databases can be replayed concurrently - Works for schema consolidation - Identify and remediate inter-application scalability and concurrency problems - Allows scale up, Subsetting, scheduling of multiple workloads - Available for 11.2.0.2 and above, MOS Note: 1453789.1 Can the system handle peak workloads, can workloads co-exist together?In the crusade to cut expenses, Data Centres (and IT Infrastructure) are now coming under scrutiny as a possible source of savings.You could even start segmenting your servers in such a way that you could have (for example) certain team members responsible for replication, others for the BI stack and SSRS servers, and still others for performance tuning.After cost reduction and efficient use of resources, there is a third common motivator I find.A company is told to buy a server with a specific amount of memory, or a specific minimum of processors, and neither of those items are ever taxed.

Running multiple application schemas in one single database, hosting multiple databases on a single platform, or a hybrid of the two configurations are all valid forms of database consolidation.

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.

There’s no doubt that this is the biggest reason cited for want to do a consolidation project.

-Database Replay enables you to effectively test system changes in test environments by capturing a full production workload and replaying on the test system to help determine the overall impact of the change.

-SPA enables you to assess the impact of system changes on SQL performance by identifying any variation in SQL executions plans and performance statistics resulting from the change Oracle Real Application Testing offers an extremely cost-effective and easy-to-use change assurance solution that enables businesses to fully assess the outcome of a system change in a test environment, take any corrective action if necessary, and then to introduce the change safely to production systems, minimizing the undesirable impact on them.

Leave a Reply