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.solonovi...@bkme.com Please consider the environment before printing this Email -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Avy Wong Sent: Saturday, August 01, 2009 5:58 PM To: ADSM-L@VM.MARIST.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."
