The Recommendation you cite is for "database utilization", not for "cache
hit ratio".  Your cache hit ratio looks healthy, at 99.1%.  I believe that
the warning for database utilization is a warning that your database is
getting full, and that you need to do something before it fills up
completely.

..Paul

At 10:58 AM 8/1/2009, Avy Wong wrote:

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

--
Paul Zarnowski                            Ph: 607-255-4757
Manager, Storage Services                 Fx: 607-255-8521
719 Rhodes Hall, Ithaca, NY 14853-3801    Em: psz1 AT cornell DOT edu