Measuring PerformanceChapter 12 CSE807.ppt

Measuring PerformanceChapter 12 CSE807 Performance Measurement To assist in guaranteeing Service Level Agreements For capacity planning For troubleshooting performance problems For Performance modeling Step I What are the information sources of performance data What are the monitoring tools available for measuring response time and resource usage What techniques are used to calculate model input parameters Sources of Performance Data Monitors Provide raw data Transformation and analysis Product specifications Manufacturers Benchmarks Performance Measurement Framework Application oriented workload Workload classes Should be tied to SLAs Responsiveness Availability Reliability Throughput Capacity Planning Frameworkper application Measure and chart as a proactive analysis as a factor of time Bandwidth usage CPU and Memory utilization End-to-end Response Time for frequently used transactions Number of concurrent users Troubleshooting Framework Monitor collect data for problem detection Paging I/O hot spots Network collisions, error rates CPU usage Queue depths Troubleshooting Framework SystemAccounting Data Example sar -u HP-UX FIADGMS1 B.11.00 B 9000/804 02/26/01 00:00:00 %usr %sys %wio %idle 01:00:00 37 8 19 35 02:00:00 22 5 34 39 03:00:00 9 2 16 73 04:00:00 7 2 14 77 05:00:00 18 4 27 51 06:00:00 6 2 14 78 07:00:00 2 2 5 91 08:00:00 1 1 4 94 08:20:00 36 2 2 60 08:40:00 51 1 1 46 09:00:00 43 2 9 46 09:20:01 35 4 15 45 Average 33 4 13 5088 Performance Tuning Framework Operating System Level Establish kernel maximum and minimum values - resource allocation per process Application and Database Level Oracle SGA