Log Cache Hit Ratio

Hi,
What would be the optimum percentage for the Log Cache Hit
Ratio?
Does this indicator at all have any purpose or
implications?
--
Thanks,
OskarI have never found a situation where that counter provided anything
useful... It has the same meaning as the data cache hit ratio, but applies
to log reads from the log cache.. ( I am not aware of any method to
configure the log cache either...)
Is your log cache hit ratio < 90%'
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
> Hi,
> What would be the optimum percentage for the Log Cache Hit
> Ratio?
> Does this indicator at all have any purpose or
> implications?
> --
> Thanks,
> Oskar|||Hi Wayne,
Yup, constantly at 50 %.
Wondering what this could mean and is it OK or not.
By the way I have SQL Server: Cache Manager: Cache Hit
Ratio steady at 70%.
--
Thanks,
Oskar
>--Original Message--
>I have never found a situation where that counter
provided anything
>useful... It has the same meaning as the data cache hit
ratio, but applies
>to log reads from the log cache.. ( I am not aware of any
method to
>configure the log cache either...)
>Is your log cache hit ratio < 90%'
>
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"Oskar" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
>> Hi,
>> What would be the optimum percentage for the Log Cache
Hit
>> Ratio?
>> Does this indicator at all have any purpose or
>> implications?
>> --
>> Thanks,
>> Oskar
>
>.
>|||Wayne,
I've never bother with this counter much at all? What is it really
measuring? Rollbacks? Reading from inserted/deleted tables in triggers?
--
Brian
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:evKwbO2tEHA.3476@.TK2MSFTNGP14.phx.gbl...
> I have never found a situation where that counter provided anything
> useful... It has the same meaning as the data cache hit ratio, but applies
> to log reads from the log cache.. ( I am not aware of any method to
> configure the log cache either...)
> Is your log cache hit ratio < 90%'
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Oskar" <anonymous@.discussions.microsoft.com> wrote in message
> news:1d8c01c4b752$e8163fb0$a501280a@.phx.gbl...
> > Hi,
> >
> > What would be the optimum percentage for the Log Cache Hit
> > Ratio?
> >
> > Does this indicator at all have any purpose or
> > implications?
> >
> > --
> > Thanks,
> > Oskar
>