1 / 52

Case Study I: A D atabase Service

Case Study I: A D atabase Service. Chapter 5. Database Service Example. A CPU Two disks Two measurement tools: A DBMS performance Monitor An OS performance Monitor. DBMS Performance Monitor log file. Co = 200 Txs T = 150 sec Xo = 200/150 = 1.33 tps.

marlin
Download Presentation

Case Study I: A D atabase Service

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Case Study I: A Database Service Chapter 5

  2. Database Service Example • A CPU • Two disks • Two measurement tools: • A DBMS performance Monitor • An OS performance Monitor

  3. DBMS Performance Monitorlog file

  4. Co = 200 Txs • T = 150 sec • Xo = 200/150 = 1.33 tps

  5. Overall System throughput is 200/150=1.33tps • U_cpu, U_d1, and U_d2 are monitored by OS Performance Monitor, • What are? • U_cpu, c1 • U_cpu, c2 • U_cpu, c3 • ……

  6. This baseline model can be used to evaluate relevant "what-if“ scenarios. • It has already been noted that performance would improve by upgrading the disk subsystem. • Also, as the predicted workload intensity changes over time, an understanding of the predicted resulting performance is also important. • For example, suppose that the workload intensity is predicted to change over the next ten months as indicated in Table 5.7. (Note • that January's workload (i.e., X = 1.33 tps) is the baseline workload intensity assumed up to this point.)

  7. (0.865-0.56)/0.856 = 35%

  8. Exercise

More Related