Finding and Fixing Performance Problems in Database-Driven Applications

Alarm SMS messages and emails are being sent by the performance monitoring system to the production DBA team and the development team alerting everyone that the latest release of a critical business application and the underlying databases are grinding to a halt. The developers, QA team, and DBAs all point fingers in each other’s direction. The developers say “My code is perfect. It passed all of the unit, system and load tests.” The QA team says “we tested and certified the code, the SQL, and the database”. The DBAs say “the production servers are configured according to the specifications and have all of the latest updates.”

Where are the problems? The IT director asks everyone these four big questions:

    1)    Application code – is the source code inefficient?
    2)    SQL code – are the SQL statements and stored procedures inefficient?
    3)    Database – is it designed and configured correctly?
    4)    Hardware – is the machine undersized or the network clogged?

In this webinar we will present a real world scenario, identify the performance and implementation issues, show how you can use the integration of ER/Studio®, Embarcadero® RAD Studio and Embarcadero® DB Optimizer™ to track down and fix the problems in the source code, the SQL and the database.

You’ll learn how a combination of tools for data modeling and schema reverse-engineering, object design, RAD development, unit testing, and SQL database profiling and tuning can:

• Give technical teams visibility into the code, data model, and database interactions in both the development cycle and in production environments
• Give the app development, database, and QA teams common tools and vocabulary for a collaborative dialog for finding, analyzing, and fixing performance issues
• Give the IT Director the factual information they need to end the blame game and foster productive discussions for taking corrective actions and allocating resources for development, database issues, and hardware upgrades

More About David:
David Intersimone (known to many as David I.) is a passionate and innovative software industry veteran (often referred to as a developer icon) who extols and educates the world on Embarcadero developer programs and runs the rampant online developer community. He shares his visions as an active member of the industry speaking circuit and is tapped as an expert source by the media. He is a long-standing champion of software developers and works to ensure that their needs are folded into Embarcadero's strategic product plans. Before Embarcadero, David spent more than 20 years with Borland in various evangelism, engineering, and development capacities, including creating the company's developer relations program. He previously served as Director of Product Services for Softsel Computer Products Inc. (now Merisel). David holds a bachelor's degree in computer science from California Polytechnic State University at San Luis Obispo, California.