is there a way to find out what how many read operations can be
satisfied in cached memory, versus how many must hit the disk?
a colleague at work said that oracle has something that will report an
XX% cache hit ratio, which is exactly what i'm going for.
several microsoft sql server articles describe trying to achieve a 95%
cache hit ratio, but they never describe where you go to find out WHAT
the cache hit ratio is.
any help figuring out where to calculate that is greatly appreciated,
jasonUsing System Monitor, you can trace various counters such as Cache, Memory,
PhysicalDisk, and some SQL Server specific counters:
http://support.microsoft.com/kb/248345/EN-US/
http://support.microsoft.com/kb/283886/EN-US/
http://www.informit.com/guides/cont...&seqNum=28&rl=1
"jason" <iaesun@.yahoo.com> wrote in message
news:1142883164.378990.101240@.i39g2000cwa.googlegroups.com...
> is there a way to find out what how many read operations can be
> satisfied in cached memory, versus how many must hit the disk?
> a colleague at work said that oracle has something that will report an
> XX% cache hit ratio, which is exactly what i'm going for.
> several microsoft sql server articles describe trying to achieve a 95%
> cache hit ratio, but they never describe where you go to find out WHAT
> the cache hit ratio is.
> any help figuring out where to calculate that is greatly appreciated,
> jason
>
No comments:
Post a Comment