Speaker: Dean Richards of Confio Software
Are you a DBA or a developer who is sometimes faced with tuning poorly performing SQL statements?
There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a solution when badly written SQLs are ruining database performance.
This presentation will walk through a process Confio Software uses with great success and will include SQL diagramming, wait type data, column selectivity, and other solutions that will help you succeed on future tuning projects.
You will learn:
- SQL Tuning Methodology
- Response Time Tuning Practices
- How to use SQL Diagramming techniques to tune SQL statements
- How to read executions plans
Dean Richards has over 20 years of performance tuning, implementation, and strategic database architecting experience. Before joining Confio, Dean was a technical director for Oracle managing key accounts and strategic alliances. Dean has focused his entire career on performance tuning of Oracle and SQL Server environments.
Comments