Database Performance and some Christmas Cheer - Page 2
January 2, 2003
Key Performance Metrics
When doing any form of database performance tuning, or applying the instructions from an article, please try and determine which of the following categories may be impacted. Most of the time more than one area will be impacted. (If you feel this list is incomplete or can't seem to make it work, please drop me a line).
If the workload has increased and people are having problems, the assumption can be made that an increase in workload will produce more of a strain on the system.
Workload is the collection of DDL (Data Definition Language) statements--the select, insert, update, and delete queries--which users and applications submit. Don't forget, it is also the administrative tasks that DBAs request of the database, everything from the scheduled backups, to the table that needs reorganization, to the indexes that have been rebuilt.
Back to our Christmas lights comparison. We need to:
Fixing the gutter to hang the lights on, or doing yard maintenance to clear a spot for the nativity scene could be compared to DDL.
When stringing lights, if it takes two hours to go to the store, pick out the nativity scene, get home, and put it up, that is the response time to the request: "Honey, I would really like a nativity scene put in the front lawn this year."
A string of lights has 200 bulbs, and takes five minutes to test for burned out bulbs. Your throughput is 200bulbs/5minutes, or 40bulbs/minute.
As a side note, if you get discouraged over the time it takes to put up all those lights, try equating the time and money you are forgoing if you were actually doing database administration work in a consulting role against the time and money you could spend to have someone else put up the lights. If the return on investment for you doing the Christmas lights is greater than someone else doing it, then great! If not, well, bah humbug.