Acceleration Software for Business-Critical Applications



 

 

 

 

Archived Performance Tips

Return to Performance Tips

November 2006

Issue date: November 2006

Challenge: How to diagnose application-to-database performance problems.

Performance of complex applications incorporating databases can perplex the most intrepidRTO PinPoint NEwsletter engineer. Whether the application is built in-house, off-the-shelf vendor software, or something to integrate from an acquisition, there are many potential “hidden” performance problems in the application-database interface.  Whether it’s poor screen design, causing an unexpected “chatty” interaction with the database, or simply not recognizing opportunities to take advantage of multi-threading, asynchronous queries or other newer technological features, the result can be the same: slow response time for the end user!

The Solution: RTO PinPoint®.

RTO PinPoint provides a broad variety of real-time and historical information for application-database interactions. For example, RTO PinPoint identifies in real-time the number of interactions, related latency and the amount of data transferred for each query, allowing you to identify problematic application-database interfaces.

RTO PinPoint also provides historical and trend data to help identify database tuning and capacity issues. DBAs and IT managers can then either “tune” database operations with existing resources, shift database resources, modify end user practices, or recommend cost-effective modification or enhancement of application-database infrastructure to optimize end user response and ROI. Using RTO PinPoint provides a unique ability to identify, isolate and optimize this critical aspect of your IT operations.


Past Performance Tips

October 2006: Solving the Citrix “Black Hole” problem.

© Copyright 2007-2010. RTO Software. All rights reserved.