Solved

SQL Server 2005 Buffer Cache Hit Rate

Posted on 2010-11-24
1
641 Views
Last Modified: 2012-08-14
I have a sql server 2005 database that is constant 100% buffer cache hit rate, 94% plus memory usage and 80% plus on the procedure cache. Would the best solution be to try and add memory?
0
Comment
Question by:bjbrown
1 Comment
 
LVL 25

Accepted Solution

by:
jogos earned 500 total points
Comment Utility
Buffer cache hit rate should be as high as possible, indicates how much sql finds its pages in cache so need for disk-read. 100% can't be beaten.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

More or less everybody in the IT market understands the basics of Networking, however when we start talking about Storage Networks, things get a bit dizzier, and this is where I would like to help.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now