database performance, sql tuning and data visualization
Tuesday, December 8, 2009
Taming the Performance Beast
Presented with Forrester's Noel Yuhanna. Noel presented on the trends that are effecting performance,why it is critical to maintain performance despite these trends, andhe outlined some best practices for overcoming these challenges. I talked about real world steps to applying these best practices as well as a live demo of our products performance Center and DB Optimizer. The full presentation is available here:
Before working at Embarcadero I redesigned the performance pages in Oracles OEM 10g (see a before and after example). I am on the patent from the team for our tuning methodology (Patents: 20060059205) . I freely provide graphical monitoring tools such as ASHMON (TCL/TK) as well as scripts to profile database load such as S-ASH ie Simulated ASH (PLSQL). S-ASH, ASHMON and more are available at my old site http://ashmasters.com/ . I have made available C code to directly read profiling data out of Oracle's memory structures, called Direct Memory Access. I speak at conferences and give classes around the world.This blog has some of my new ideas on Visual SQL Tuning (VST), work on DB Optimizer, possibly some past material on DB performance monitoring as well as lots of references and pointers to other information on the web that I find important and worth emphasizing.