Embarcadero
Sql_Webinar_Morton_680x150_noDate

On-Demand: Diagnosing SQL Performance Problems

As a DBA, the initial shock caused by the appearance of a critical performance problem in one of your databases can sometimes lead you to utilize inefficient methods to find, diagnose, and resolve the root cause issue. There are numerous areas within your environment from where problems can appear, but one of the most frequent root causes of performance-related issues is SQL.

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 will learn how to:

First Name

*

Last Name

*

Company

*

Title

*

Email Address

*

Phone

*

State/Province

*

Country

*

 

 

• 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



About Karen Morton

Karen Morton is a consultant and educator specializing in application optimization in both shoulder-to-shoulder consulting engagements and classroom settings. She is a Senior DBA Performance and Tuning Specialist.

For over 20 years, Karen has worked in information technology. Starting as a mainframe programmer and developer, she has been a DBA, a data architect and now is a researcher, educator and consultant. Having used Oracle since the early 90's, she began teaching others how to use Oracle over a decade ago.

Karen is a frequent speaker at conferences and user groups, an Oracle ACE, and a member of the OakTable network (an informal association of "Oracle scientists" that are well known throughout the Oracle community). She blogs at karenmorton.blogspot.com.