Try OpenEdge Now
skip to main content
Database Essentials
Database Administration : Profiling your system performance : Establishing a performance baseline : Collecting your baseline statistics
 
Collecting your baseline statistics
Once you have determined what operations you want to benchmark, you can plan your strategy.
You can modify the application code to collect benchmark data, which is the most accurate method, but it is also time consuming and costly. An easier way to perform data collection is to time the operations on a stopwatch. This is fairly accurate and easy to implement. To determine the best timing baseline for each task, perform timing in isolation while nothing else is running on the system. When timing baselines have been established, repeat the task during hours of operation to establish your under-load baselines.