The MoreVRP for BI, DW and OLAP Applications solution serves IT teams in meeting the difficult challenges of managing resource loads in databases and datacenters running Business Intelligence, Data Warehouse and other on-line application processing solutions.  Typically these solutions generate complex transactions and queries that consume enormous CPU resources and IO bandwidth, causing heavy loads on the system that impair performance and extend response time for all concurrent users and active transactions.

The MoreVRP DW/BI/OLAP solution features a predefined rules engine module that manages the intensive resource requirements of these applications in the context of the other applications in use, accelerating compliance with enterprise business priorities. MoreVRP facilitates concurrent BI batches, backups and other heavy transactions at any time of day by simply limiting their resources instead of postponing or “killing” them.  MoreVRP improves handling of a variety of DW, BI and OLAP operations, including reports, background / scheduled reports, regular ETL processes, interfaces to additional systems & applications, data archiving,  application maintenance tasks (backups; statistics; indexing, etc.)

With the MoreVRP solution, IT teams and their DBAs need spend less time resolving bottlenecks and managing crises, freeing them to invest more time in application and database optimization and development.

MoreVRP for BI, DW and OLAP Applications Key Values:

• Robust instantaneous data monitoring, alerts and control
• Automated, highly granular rules generation engine
• Intuitive rules wizard for end-users simplifies rules generation against business priorities
• Log & Historical Applications Analysis Tool
• Tuning task manager tracks resolution of problematic transactions and processes

MoreVRP for BI, DW and OLAP Applications Key Benefits:

• Improved SLA compliance, consistent QoS, improved end-user satisfaction and greater business productivity
• Faster ETL processes that result in better and more accurate BI
• More interfaces for the DW
• 20-40% better HW utilization, 20-40% fewer performance cases (tickets) annually