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
