Veracity

TECHNOLOGY

MORE's pioneering technology and unique product offering are dedicated to high standards of excellence, supported by experienced software developers, DBA specialists, and a dedicated management team whose goal is to deliver superior Virtual Resources Partitioning (VRP) solutions to a wide range of companies and organizations.

Most databases have performance issues due to varying load peaks. Heavy I/O or CPU-bound database transactions can cause all transactions to have longer response times, with some loads resulting in a complete system crash.

The transaction within the database is derived from a business transaction or process. MoreVRP allows you to take the virtualization to the transaction level. Doing so, immediately influences the performance of the transaction - which translates to the performance of the business transaction. There is a straight and clear connection line from MORE-VRP to the business transaction performance.

MORE's technology eliminates the need to terminate a loading query, scheduling transactions or separating the BI/DW environment from the production that is required to separate the load. Ultimately, this leads to better response times and improved QoS. MORE's VRP technology provides real-time capabilities to handle and solve unexpected heavy system loads by simply distributing system resources more efficiently, using either pre-defined or ad-hoc rules, and stabilizing the system to get the best possible hardware performance.

VRP Overview

More-VRP works on the operating system's inter-process level, underneath the database. It is fully transparent to the database, so that no architectural changes are required.
More-VRP technology 'listens' to all the traffic between the database and the operating system, without interfering, correlates the data with information gathered from the database, and when a rule is triggered, More-VRP instructs the operating system to allocate the selected amount of CPU and IO to a specific operation. This is achieved by creating narrower virtual resource lanes to the CPU and IO drivers, and redirecting managed transactions to these virtual lanes. More-VRP monitors all of the various processes, and generates detailed operational, statistic & analyzing reports.

More-VRP can easily control and manage any type of transaction, from SQL queries (select statements) and loading processes (DML - Inserts, Updates, Deletes), to reorganization processes (index rebuilds, table movements) and statistics collection (analyze commands).

MORE-VRP supports a wide range of DB-based enterprise environments, including ERP, CRM, DW, in house applications, and other mission-critical applications.

MORE-VRP supports:
DB2 ver.8.5 & ver.9
ORACLE 7 to 11G Standard & Enterprise Editions
MS-SQL 2005

Operating systems, including:
Red Hat Linux, SUSE, Linux, Sun Solaris, HPUX, IBM AIX, Windows (2000 and higher), and TRU64.

High Availability

In enterprise organizations where maximum availability is required for business continuity, an availability solution for MORE is absolutely crucial. MORE-VRP can be configured in a clustered environment to ensure maximum availability for load management, and during server failures.

Footprint

MORE-VRP agent footprint in an average database is 0.5% of a single CPU, where, for example, a machine with four CPUs, MORE-VRP uses ~0.12% of the total machine. The system's console is installed on a Windows PC/Server on the network, and collects various statistics, correlates them, then logs them into an internal repository.

Monitoring

The system can be easily monitored and controlled by pre-defined rules, and corrected as required. When a rule is defined, the virtual partitioning of the server's resources is performed immediately. Fully transparent to the database, it does not require special configuration at the DB level. Data is clearly displayed on MORE's unique system dashboard. The dashboard allows users (DBAs and managers) to identify problems in the SLA, and pinpoint any heavy transaction that may be the cause of the problem. Users can create rules and prioritize the resource usage directly from the dashboard.

API

MORE-VRP easily integrates with various monitoring tools by means of a built-in API. Any 3rd party monitoring tool such as Tivoli, Unicenter, HPOV, Grid control, Patrol, and others can connect More-VRP using the built-in API and read MoreVRP counters, or alternatively, activate the VRP management mechanism.

Reports & Alerts

MORE-VRP is equipped with built-in state-of-the-art reporting capabilities, To best evaluate database behavior and enable users to create efficient rules, MORE constantly logs the traffic into a repository. The repository can then be analyzed using MORE-VRP reporting capabilities, to drill down into problematic peak periods, SLA trends, and abnormal events. However, users can easily convert data to standard CSV/XML files and integrate the repository with any other 3rd party BI tools, including BO, Congnos, Discoverer and others.

Installation

Installation takes between 2-4 hours, with full implementation 3-5 days, during which time a trained and certified MORE technician works on-site or from a remote location. Following implementation, users can fully control and manage their database load, and prioritize transactions within their own database.