Don’t Expect Miracles from your Database Administrator

My previous post focused on the contribution of the Database Administrator (DBA) to application performance. Even so, application performance depends upon many factors, some of which are beyond the control of even the most dedicated DBA. So if you were thinking of relying on your DBA to fix everything, this week’s performance principle provides is [...]

Be Nice to a DataBase Administrator Today

The annual Computer History Museum Fellow Awards program publicly recognizes individuals of outstanding merit who have significantly contributed to advances in computing technology or applications, and to the evolution of the information age. Fellows may have worked in such diverse fields as hardware, software, networking, computer science, business, education, public service, or journalism, but they [...]

Monitor Standard Application Scenarios

In recent years, much has been written about the value of use cases and scenarios for capturing functional requirements; by comparison, their usefulness for performance management has received scant attention .  An application scenario defined for performance management purposes:

Involves a known fixed workload
Runs in the normal production environment
Runs against the production databases
Is instrumented to record [...]

Newton’s First Law of Performance Monitoring

If Sir Isaac Newton were stating the laws of computer systems performance, his first law would surely have been: The graph of performance continues in a straight line unless the force of some external event causes it to change.

Not knowing what changed is a serious impediment to problem diagnosis.

How does performance suddenly become “abnormal”? Of [...]