Tools, Methods, Techniques for the Enterprise Database Professional
SAP + Siebel + PeopleSoft + JD Edwards
This deck presents a systematic way of defining and solving performance issues with Oracle Applications. It gives an overview of how disk architecture impacts performance, how to run a trace, and reproduce the queries properly outside of the application.
Please go to www.computationpress.com website to download this deck.
posted by Frank McBath at 4:39 PM
0 comments
I have uploaded my Performance Methodology Poster (PDF format) to the Computation Press website:
The poster outlines steps and scripts needed to go in and resolve performance issues with enterprise applications (ERP & CRM).
posted by Frank McBath at 4:32 PM
0 comments
I have posted the deck I give at conferences on database and disk drives. It's a "shorter" deck (ie. One hour talk), instead of the larger deck I sometimes use that covers 4 hours.
A short abstract:
It focuses on how to create a scalable database solution on everything from direct attached SCSI to SANs. The deck covers perfmon counters, partition alignment, SQL IO performance testing, proper number of files for space management, etc...
posted by Frank McBath at 4:30 PM
1 comments
Database + Disk + Performance
I have been in IT for over 18 years, with the last decade focused on enterprise applications and databases. My background has been in a variety of roles-- consulting, outsourcing/hosting, pre&post sales tech support, and production support. Currently I work for a large software company in an enterprise apps architecture role.
I have written or co-authored 5 books on SQL Server for Microsoft Press and Prentice Hall. Additionally, I'm a regular presenter at conferences on database performance and design with enterprise apps in the US, Asia and Europe.
All materials on this website are Copyright (c) 2006 by Frank E. McBath.
All rights reserve. No part of this website may be reproduced or transmitted in any form or by any means without permission in writing from the author.
