Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server 2005 Buffer Cache Hit Rate

Posted on 2010-11-24
1
Medium Priority
?
695 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 2000 total points
ID: 34209623
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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
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 setup several different housekeeping processes for a SQL Server.

886 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