Hi, I belong to the DB2 Performance Expert development team, and one of my roles is to support customers and help them to get the most out of the product. DB2 Performance Expert for Linux, UNIX, and Windows 3.2
and the new DB2 Performance Expert Extended Insight Feature
for end-to-end database monitoring of Java applications is now available. The Performance Expert Extended Insight Feature gives DBAs a new view into the performance of Java database applications. It helps to:
- Improve availability of mission-critical Java database applications by detecting negative trends sooner
- You can look from different workload scope levels at your Java database applications and get transaction response time values. For example,you can look at the end users of your Java database applications and see what response time each individual user gets. If you see high response time differences, then you can drill down and see whether they execute different SQL statements. Or maybe one user uses another WebSphere Application Server machine than the others and that machine is differently configured which leads to longer response times in general.
- Manage applications to meet service level agreements more easily and effectively
- You can set warning and problem thresholds on response time values that meet your service level agreements. Graphical displays and signal lights warn you immediately when these thresholds are breached.
- Reduce time needed to isolate performance issues from days to minutes using graphical displays
- Response time graphs show you the average and maximum end-to-end response time over time on your selected workload scope level ( e.g. per application or per user). Any response time changes or peaks can be detected easily. Additionally, a histogram shows you the distribution of the response times of all transactions.
- Improve collaboration between DBAs and other members of the IT organization by providing key performance indicators across the software stack
- Key performance indicators include the average end-to-end response of a transaction as well as part of the response time that were spent in the application, the driver, the network and the data server. By looking at these time spent metrics you know immediately where in the software stack the time was spent in order to identify problems.
It’s sometimes difficult to explain the real value of what we call end to end database monitoring in words (although you can read about it in this article
), so I wanted to use this as an opportunity to introduce you to a short demo
that I think is worth more than a thousand words.
Thuan mentioned this video in Monday's posting. It's a live demo given by the lead architect of DB2 Performance Expert, Torsten Steinbach. In the demo you learn how easy it is to identify SQL statements that are responsible for a bad response time and to identify who issued the SQL statement and where the SQL statement spent it is time ( application, driver, network or data server ). Take a look at the video to get a first impression on this great new feature of DB2 Performance Expert.
Please let me know by adding a comment to this blog or sending an email to email@example.com if you have any specific questions about DB2 Performance Expert you would like me to address in future blog entries.