Tuesday, July 31, 2012

Diagnosing SQL Performance Problems Webinar Followup

Thanks to everyone who joined me for part 1 of my Oracle SQL Performance webinar series! Embarcadero will be posting the recording within the next few days. In the meantime, I thought I'd post the slides and a few scripts that were shown.

Thanks again and I hope to see you again next month for part 2!

Presentation slides (PDF)
Scripts (ZIP)

Tuesday, July 17, 2012

July 31 Webinar

Please join me for another Embarcadero sponsored Community Webinar on July 31. This is the first in a series of three webinars. My topics for this triple feature are:
Making SQL Performance Solutions "Stick"
Making Impactful Performance Changes

Here's a bit about what I'll cover in this first event:
Karen Morton begins her DBA Performance Series with Diagnosing SQL Performance Problems, designed to help DBAs understand the context in which SQL problems arise and present a framework to efficiently diagnose SQL issues, including: immediate items to identify, rule out, and confirm as well as identifying "fast" fixes to get performance back on track quickly.

You'll learn
  • How to distinguish between SQL and non-SQL performance optimization issues.
  • How to target typical cases that cause SQL to perform poorly and resolve them without rewriting SQL.
  • How to identify when a SQL statement needs to be rewritten to permanently solve performance inconsistencies.
Thanks again to Embarcadero for sponsoring the event and I hope to "see" you there!