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
             <psz1 AT CORNELL DOT EDU
             >                                                          To
             Sent by: "ADSM:           ADSM-L AT VM.MARIST DOT EDU
             Dist Stor                                                  cc
             Manager"
             <[email protected]                                     Subject
             .EDU>                     Re: [ADSM-L] Database Cache Hit
                                       Ratio

             08/01/2009 11:08
             AM


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .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: psz1 AT cornell DOT edu