Data cache monitor


Job details

Name: Data cache monitor
Platform: Sybase
Category: Performance
Description: Collects data cache statistics based on the dbWatch tasks ‘System monitor collector’ which runs the ‘dbcc monitor’ utility continuously.
Long description:
Version: 1.3
Default schedule: 0,10,20,30,40,50 * * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sybase’]/instance[maj_version = ‘12′ & hasengine=‘YES’]

Parameters

Name Default value Description
history threshold 48 The amount of hours the statistics will be hold in the history table.

Job Summary

select t1.histr_date, sum((t1.value*1)/t1.elaps_time) calls, sum((t2.value*1)/t2.elaps_time) finds, 100.0 * sum(t2.value)/sum(t1.value) HR, t1.elaps_time from dbw_data_cache_histr t1, dbw_data_cache_histr t2 where t1.group_name = t2.group_name and t1.histr_date=t2.histr_date and t1.field_name='bufsearch_calls' and t2.field_name='bufsearch_finds'  and t1.elaps_time > 0 and t2.elaps_time > 0 group by t1.histr_date,  t1.elaps_time having sum(t1.value) > 0 order by 1 asc

Key Features and Reports

Tables and Charts Included in the Report

Data Cache Statistics Report Sections Description
Data cache statistics Shows historical data cache hit ratio
Data cache configuration Details the configuration of each data cache buffer
Hit ratio for each buffer Displays hit ratio segmented by individual cache buffers

Implementation Details

Dependencies and Cleanup Procedures

Version and Company

By maintaining this monitoring setup, database administrators ensure optimal data cache utilization and performance, leading to overall enhanced performance of the database system.