iWay Resource Analyzer
Enterprise-Wide Resource Performance and Usage Analysis
Knowledge really is power. When you know how your enterprise information is being used, you have the power to optimize it, secure it, and modify it to achieve consistent, outstanding performance. iWay Software's Resource Analyzer provides over 80 detailed reports and graphs to help you discover how your e-business applications use your information, including:
- Usage characteristics such as heaviest usage times, most requested content and aggregations, and applications using the most resources
- Performance characteristics such as average or maximum CPU consumption per request, average or maximum response time, number of records returned, and maximum cumulative CPU or response time per request
Resource Analyzer is part of iWay's comprehensive solution set for building, managing, and optimizing a data architecture that supports multiple latency and access requirements of various IT initiatives – including business intelligence, real-time reporting and analysis, and business activity monitoring.
Resource Analyzer can help your e-business applications operate at peak efficiency for maximum return on investment. By identifying specific bottlenecks and inefficiencies in your environment, you can eliminate resource contention and:
- Long-running requests. These requests use excessive resources – a particular problem when dealing with operational systems – and result in long waits for consumers. Target these requests for optimization first.
- Excessive joins. Joining too many tables is expensive and slow. Stage data from many tables into one for better performance and navigability.
- Repeated aggregations. Aggregations can cause a bottleneck during query execution. Improve performance by precalculating the aggregations and staging them in summary tables.
- Poor selection criteria. Indexes increase selection speeds but impede update and insertion performance. Identify those fields that really need to be indexed and eliminate those that don't. Times of heaviest workload. All e-business systems experience peaks and valleys of demand. Manage peak loads and justify infrastructure expenditures by identifying your heaviest resource consumption times by hour, day, week, or month. Query volumes. Untuned queries frequently return more data than necessary. Identify these queries so you can target them for optimization.
