-
Performance monitoring, Immediate help needed! (reply)
Thanks a lot. If it is possible, can you give a little more detail about
that buffer cache hit ratio is application specific? or please kindly direct
me to some recommended literature regarding this issue.
------------
Ray Miao at 2/20/2002 12:34:38 PM
Cache hit ratio is for data cache while buffer cache hit ratio is application specific. You need more memory since cache hit ratio is below 50%.
------------
Lu at 2/20/2002 10:05:50 AM
I ran a NT performance monitoring included serveral SQL specific counters.
I don't understand some of the results. Buffer cache hit ratio in SQL server Buffer Manager is close to 100%. But Cache hit ratio in SQL server Cache Manager is below 50%. Would you please help me in analyzing thoes data?
What is the real difference between those two counters.
Thanks a lot!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|