RDBPROD Fragmented SQLServices Dispatcher and Monitor logs and system performance
edited Jan 10, 2014 6:42AM in Rdb on OpenVMS, IBM zSeries and Oracle on OpenVMS (MOSC) 4 commentsAnswered
Hello everyone !!
Do badly fragmented Dispatcher and Monitor logs
from SQL Services cause a significant degradation of the system
performance ?
After runnig a VMS_CHECK procedure I have a report that says:
" The fragmentation index is 88.3
1 - 20.9 is excellent
21 - 40.9 is good
41 - 60.9 is fair
61 - 80.9 is poor
81 - 100 indicates a badly fragmented disk
Approximately 68.3 (out of 80.0 possible) is due to file fragmentation
Approximately 20.0 (out of 20.0 possible) is due to freespace fragmentation
Freespace Summary:
Total free space: 34979936 blocks
Total free extents: 7907
Maximum free extent: 14079079 blocks, LBN: 57052828
Minimum free extent: 137 blocks, LBN: 24216531
Average free extent: 4423 blocks
Median free extent: 137 blocks
File Fragmentation Summary:
Do badly fragmented Dispatcher and Monitor logs
from SQL Services cause a significant degradation of the system
performance ?
After runnig a VMS_CHECK procedure I have a report that says:
" The fragmentation index is 88.3
1 - 20.9 is excellent
21 - 40.9 is good
41 - 60.9 is fair
61 - 80.9 is poor
81 - 100 indicates a badly fragmented disk
Approximately 68.3 (out of 80.0 possible) is due to file fragmentation
Approximately 20.0 (out of 20.0 possible) is due to freespace fragmentation
Freespace Summary:
Total free space: 34979936 blocks
Total free extents: 7907
Maximum free extent: 14079079 blocks, LBN: 57052828
Minimum free extent: 137 blocks, LBN: 24216531
Average free extent: 4423 blocks
Median free extent: 137 blocks
File Fragmentation Summary:
0