The analysis of DB2 stored procedure performance can get tricky. You can have a stored procedure that calls another stored procedure and on it goes. How do you determine exactly what these routines are doing?
The upcoming webcast, "Expert stored procedure monitoring, analysis and tuning on System z" goes into the new stored procedure monitoring and analysis capabilities of OMEGAMON XE For DB2 Performance Expert (note you need to have Performance Expert for this support).
The webcast will cover:
- Identifying and exposing the mystery behind slow performing stored procedures
- Drilling down to explore every facet of a stored procedure’s performance breakdown
- Identifying SQL performance problems quickly throughout layers of complex applications
- Grouping SQL statements into workloads to compare and track performance improvements
It sounds like an intereesting topic that covers a very powerful new OMEGAMON feature.
The speaker is Charles Lewis, DB2 Advisor and Senior Certified System z Software Technical Professional, IBM. The event is April 23, 2013 at 11:00 a.m. EDT.
To attend, here's the URL: