Increase the capacity of the database. At 11:13 AM 8/1/2009, Avy Wong wrote:
Any recommendations to resolve this ?Avy Wong Business Continuity Administrator Mohegan Sun 1 Mohegan Sun Blvd Uncasville, CT 06382 (860)862-8164 (cell) (860)961-6976 Paul Zarnowski <p...@cornell.edu > To Sent by: "ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager" <ads...@vm.marist Subject .EDU> Re: [ADSM-L] Database Cache Hit Ratio 08/01/2009 11:08 AM Please respond to "ADSM: Dist Stor Manager" <ads...@vm.marist .EDU> 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: p...@cornell.edu
-- Paul Zarnowski Ph: 607-255-4757 Manager, Storage Services Fx: 607-255-8521 719 Rhodes Hall, Ithaca, NY 14853-3801 Em: p...@cornell.edu
