Articles & Content

Archives

SQL Assurance

Topic: 2013 AU

Subtopic: DB2 for z/OS



We all know that SQL in production should be performing at the absolute best that it can – and the market is

full of tools to help you monitor and measure that performance, hopefully against some stated service level

agreement



But how does high performance SQL get into production in the first place. Do you ensure that it is coded in

the best way possible right at the start of the development lifecycle, or do you only address performance

issues when the SQL is about to be promoted into production (or perhaps only AFTER it has been migrated)?



This presentation looks at some ways it may be possible to “quality assure” your SQL as it is promoted

through the different environments



We will also look at some development situations that would seem to make SQL QA an almost impossible

task



Finally, we’ll finish off with some thoughts on what constitutes normal performance and how could it be

possible for a performance monitor to track normality and raise alerts for exceptions – all without annual

intervention



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.