![モニタリング結果の例](/images/new-backgrounds/25485/25485361x1.webp)
第 6 章 パフォーマンスのモニタリングとチューニング
モニタリング結果の例
この項では、いろいろなモニタリング・オプションを使用したサンプル結果を 示します。
Sybase Adaptive Server IQ Performance Monitor
Version 3.2
Options string for Main cache:
|
|
|
|
|
|
|
|
|
| Summary | |
|
|
|
|
|
|
|
|
| 13:53:24 | ||
Active |
|
|
| Main Cache |
|
| Temp Cache | ||||
Users | Finds | HR% | Reads/Writes GDirty | Pin% Dirty% InUse% | Finds | HR% | |||||
Reads/Writes | GDirty | Pin% Dirty% InUse% |
|
|
|
|
| ||||
0 | 286 | 99.3 |
| 2/34 | 0 | 0.0 | 1.6 | 26.2 | 608 | 99.7 | |
2/47 |
| 0 | 0.0 |
| 3.6 | 20.0 |
|
|
|
|
|
1 | 2621 | 99.4 |
| 16/155 | 0 | 5.6 | 8.7 | 81.7 | 4121 | 99.6 | |
16/163 |
| 0 | 11.4 | 23.2 | 67.3 |
|
|
|
|
| |
1 | 2646 | 99.8 |
| 6/48 | 0 | 1.6 | 13.5 | 100.0 | 3388 | 99.8 | |
6/70 |
| 1 | 4.1 |
| 40.9 | 94.5 |
|
|
|
|
|
1 | 2684 | 99.9 |
| 7/78 | 0 | 5.6 | 14.3 | 100.0 | 3497 | 99.9 | |
8/103 |
| 1 | 10.9 |
| 42.3 | 99.1 |
|
|
|
|
|
1 | 1993 | 99.9 |
| 17/22 | 0 | 4.0 | 31.0 | 100.0 | 3342 | 98.7 | |
122/149 |
| 0 | 8.2 | 41.4 | 91.4 |
|
|
|
|
| |
1 | 2479 | 99.9 |
| 32/110 | 0 | 5.6 | 13.5 | 100.0 | 3370 | 99.8 | |
55/112 |
| 0 | 11.4 | 45.5 | 95.9 |
|
|
|
|
| |
1 | 3273 | 100.0 |
| 0/0 | 0 | 5.6 | 23.8 | 100.0 | 3951 | 100.0 | |
0/108 |
| 1 | 13.6 |
| 49.1 | 100.0 |
|
|
|
|
|
1 | 2512 | 99.9 |
| 2/0 | 0 | 1.6 | 31.0 | 100.0 | 3916 | 98.9 | |
88/173 |
| 0 | 5.5 | 48.6 | 100.0 |
|
|
|
|
| |
1 | 1264 | 99.9 |
| 66/131 | 0 | 4.0 | 45.2 | 100.0 | 4317 | 98.9 | |
378/305 |
| 0 | 6.4 | 40.0 | 77.3 |
|
|
|
|
| |
1 | 2122 | 99.8 |
| 30/125 | 0 | 5.6 | 12.7 | 99.2 | 3122 | 99.7 | |
67/127 |
| 0 | 12.3 | 40.0 | 90.5 |
|
|
|
|
| |
1 | 3370 | 100.0 |
| 2/0 | 0 | 5.6 | 23.0 | 100.0 | 4034 | 100.0 | |
2/98 |
| 2 | 13.2 |
| 46.4 | 98.2 |
|
|
|
|
|
パフォーマンス&チューニング・ガイド | 165 |