Re: [ADSM-L] Database Cache Hit Ratio
2009-08-02 04:15:34
I think your problem has no relationship with cash ratio:
" The database utilization is too high. 85.4 > 85 Consider a database space
trigger or increase the size of the database."
Just increase database size to have less than 85.
Cash ratio has to be as high as possible.
Grigori G. Solonovitch
Senior Technical Architect
Information Technology Bank of Kuwait and Middle East http://www.bkme.com
Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: G.Solonovitch AT bkme
DOT com
Please consider the environment before printing this Email
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Avy Wong
Sent: Saturday, August 01, 2009 5:58 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Database Cache Hit Ratio
Hello,
In one of my TSM report, I see it says my database cash hit Ratio too
high. What is the normal ratio? What do I have to do to bring it down or
ways to resolve this?
Thank you for your help.
Issue Condition Recommendation
The database utilization is too high. 85.4 > 85 Consider a database space
trigger or increase the size of the database.
[-] Custom Summary
Item Results
Administrative Schedules Successful: 6
Administrative Schedules Errors: 0
Administrative Schedules Failed: 0
Administrative Schedules Missed: 0
Client Schedules Completed with No Errors: 55
Client Schedules Completed with Skipped Files: 35
Client Schedules Completed with Warnings: 0
Client Schedules Completed with Errors: 0
Client Schedules Failed: 0
Client Schedules Missed: 0
Scheduled Nodes with empty contact information: 87
Total GB Backed Up: 1285.66
Total GB Restored:
Total GB Archived: 160.81
Total GB Retrieved: 0.01
Last Database Backup: 2009-08-01 00:46
% Database Utilization: 85.4
Database Cache Hit Ratio: 99.1
% Maximum Recovery Log Utilization: 14.3
Disk Pool Total MB: 2007040.0
% Disk Pool Utilization: 16.1
Disk volumes offline: 0
Number of drives: 7
Number of tape mounts: 144
Total number of minutes tapes were mounted: 3855
Total number of volumes: 333
Number of scratch volumes: 57
Number of unavailable volumes: 0
Number of read-only volumes: 20
Volume Reclamation warning: 126
Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
(860)862-8164
(cell) (860)961-6976
Please consider the environment before printing this Email.
"This email message and any attachments transmitted with it may contain
confidential and proprietary information, intended only for the named
recipient(s). If you have received this message in error, or if you are not the
named recipient(s), please delete this email after notifying the sender
immediately. BKME cannot guarantee the integrity of this communication and
accepts no liability for any damage caused by this email or its attachments due
to viruses, any other defects, interception or unauthorized modification. The
information, views, opinions and comments of this message are those of the
individual and not necessarily endorsed by BKME."
|
|
|