Solved

SQL Server 2005 Buffer Cache Hit Rate

Posted on 2010-11-24
1
673 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
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

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Pivot with row total 5 27
Check ALL SP in database make sure there are no errors 17 43
Are triggers slow? 7 11
Where is the Help Section? 8 25
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

839 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