“SQL Workload Monitoring and Tuning - Understand your SQL Workload and Uncover the Perfect DB2

Linda Adams

“SQL Workload Monitoring and Tuning - Understand your SQL Workload and Uncover the Perfect DB2









Hi DB2 Listserv:

“SQL Workload Monitoring and Tuning - Understand your SQL Workload and Uncover the Perfect DB2 setup” with Thomas Sprenger, ITGain Software

The International DB2 Users Group (IDUG) is pleased to partner with ITGain Software to deliver a free Webcast with presenter Thomas Sprenger who is a DB2 senior consultant and has worked extensively with AIX, DB2 UDB as an enterprise architect.

About the Webcast:
This live web cast will run approximately 60 minutes.

This presentation will answer questions such as:
§ What are the resources that hurt me most?
§ How do I collect my SQL workload in an efficient manner?
§ How to handle the SQL swarm: The Pro's and Con's of normed SQL statements
§ How do I identify the index tuning potential?
§ How do I rate the recommended indexes and identify the important ones?

The presentation, and scripts and statements used during the presentation will be made available afterwards to attendees free of charge.

About the Presenter:
Thomas Sprenger is a Senior DB2 Consultant whose work has had its origins in the fields of AIX and High Availability sectors respectively.

He has worked as a Strategy Consultant in the area of Enterprise Architecture and is currently involved in complex DB2 performance tuning projects for some very large corporations in Europe.

In this capacity he is responsible for defining the upcoming SQL tuning and monitoring facility of ITGain's DB2 LUW monitoring software SPEEDGAIN for DB2.

Webcast Schedule Times:
Tuesday, January 18, 2011 5:00 pm Europe Time (Berlin, GMT+01:00)
Tuesday, January 18, 2011 9:00 am Mountain Standard Time (Denver, GMT-07:00)
Tuesday, January 18, 2011 10:00 am Central Standard Time (Chicago, GMT-06:00)
Tuesday, January 18, 2011 8:00 am Pacific Standard Time (San Francisco, GMT-08:00)

To register:
https://itgain-webinare.webex.com/mw0306lb/mywebex/default.do?siteurl=itgain-webinare-en&service=6

For more information don’t forget to visit the IDUG website at www.idug.org

David Chapman.
c/o Linda Adams
IDUG Web Team

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv