Centerfield Technology, Inc
3131 Superior Dr NW
Rochester, MN 55901

Slow application performance

While it's true that the iSeries database is shipped pre-tuned for traditional RPG applications, there is an increasing number of situations where additional time is required to fine-tune the database, including:

  • A query intensive SQL environment in which it is difficult for the iSeries administrator to anticipate which indexes should be pre-built and which indexes should be built temporarily by the system
  • An environment which relies on a frequently updated legacy application with a number of different developers writing SQL code that would benefit from a fast and efficient way of testing for performance BEFORE deployment
  • A system of OLTP applications and reports which increasingly relies on SQL rather than more traditional RPG programming and administration skills. SQL-based applications tend to be multi-platform, very complex, and posses difficult-to-understand query optimization technology

The Centerfield Technology Solution? insure/INDEX and insure/ANALYSIS.

These tools provide a proven way to efficiently capture critical performance information, isolate the problem SQL statements, and identify performance tuning opportunities. The built-in methodology and intuitive graphical interface greatly reduces the complexity of the tuning process saving money, wasted effort, and frustration.

The ability to identify problems and associated fixes in a timely manner is critical in today's fast-pasted business environment. The intuitive graphical interface in these tools provides a wizard-driven approach to assist those new to managing complex applications and database access.

insure/INDEX and insure/ANALYSIS fit into these high volume environments by providing:

  • Pinpoint data collections to minimize CPU and disk overhead
  • Automatic index recommendations based on your workload
  • Drill down analysis to minimize time spent sifting though data
  • An environment where it is safe and straightforward to experiment with different tuning options

Question / Quote Request?

Name
 
Phone

Email Address
 
Comments

Newsletter Subscription

 
 
(Past Newsletters)