One statistic that most administrators do not keep track of is the amount of work that is completed per day on their systems. By monitoring database activity such as commits and database requests, you can determine when the greatest workload on the system occurs, and the growth pattern of this workload over time.
Workload information can be valuable information. If you encounter a problem, you can see whether there is an abnormal workload on the system or if there is some other issue. In cases where additional customer records are added to the database, you might notice that the workload on the system is increasing even though the number of users and the number of transactions are not increasing. This indicates that there might be an application efficiency issue that needs to be addressed before it becomes a problem. It will also help you to understand your need for additional resources prior to loading more records into the database. By knowing this information prior to the event, you can plan effectively.
