Here is the deal.
Buffer Cache Hit Ratio is consistently above 98% BUT my IO seems to be going
nuts too (High).
Doesnt this seem kinda ironic ?
thanks
GAJNot really. You could be writing data out at a high rate. Also, Buffer
cache hit ratio includes hits from prefetch, so if read-ahead is working,
the cache could be loaded before the query actually needs the information.
Cache hit ratio is only one number to look at to determine the health of a
SQL server.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jaxon" <GregoryAJackson@.hotmail.com> wrote in message
news:O565akZ8DHA.2952@.TK2MSFTNGP09.phx.gbl...
> Here is the deal.
> Buffer Cache Hit Ratio is consistently above 98% BUT my IO seems to be
going
> nuts too (High).
> Doesnt this seem kinda ironic ?
>
>
> thanks
>
> GAJ
>|||ok, Thanks
gaj
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment