We recently returned from IOD, which was quite an intense experience for those of you who have never been. We both gave lots of demos and talked to lots of customers about the Optim Query tuning solutions. And you can imagine that any session on query tuning, with or without a tools focus, was really packed. It seems as if people can never hear enough about query tuning, because it’s actually pretty interesting to do, and because it can have such an impact to the day to day life of a DBA (or whoever in your organization is tasked with reviewing and turning queries and query workloads).
Ray blogged earlier about how important it is that developers and DBAs collaborate more in the query tuning process. Not only can developers build up their skills, they can hopefully come to the DBA with some of the basic stuff taken care of, or at least a better understanding of what the issues are. The earlier in the cycle that issues are discovered, the less expensive and labor-intensive the tuning process is.
Anyway, we wanted to share with everyone who could not make the conference some scenario-based demonstrations of how query tuning solutions can work together. We are co-presenting at an upcoming Virtual Tech briefing (complimentary!) on November 19th. The focus of this is on z/OS, so we’ll talk about query tuning from both a development and DBA perspective, and discuss how to use Optim (such as Optim Development Studio, Optim Query Tuner and Optim Query Workload Tuner) and other z/OS tools to work through some typical scenarios. The scenarios we are planning to cover include:
- A development time scenario in which query tuning capabilities and reporting are available directly from the development environment.
- Invoking query tuning capabilities from a monitoring environment such as OMEGAMON and Query Monitor
- How you can use Query Workload Tuning in a version to version migration scenario
- Workload analysis capabilities and an index advisor walkthrough.
We hope you can join us. Register today!
Ray and Saghi