Troubleshooting SQL Buffer Cache Hit Ratio

lasmith3

This issue just happen recently. The buffer cache ratio went from > 90%
to 50% and has slowly been climbing back up over 8 hours or so. Its
currently @ 76%. Is this something I should take action on immediately?
It seems to be coming back to normal...

Jul 23 '05 #1

Subscribe Post Reply

5579

Erland Sommarskog

(la******@pacbell.net) writes:

This issue just happen recently. The buffer cache ratio went from > 90%
to 50% and has slowly been climbing back up over 8 hours or so. Its
currently @ 76%. Is this something I should take action on immediately?
It seems to be coming back to normal...

Seems like there been some unsual event.

Maybe someone ran a bad query which required scanning of one or more
big tables, and this squeezed out data from the cache.

Someone might also have run DBCC DROPCLEANBUFFERS, and flushed the
cache entirely. But that case I would guess you would bave been down
to 0% for a short while.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 23 '05 #2

Similar topics

Cache HIT ratio problem

by: Matt | last post by:

Hello I am tring to figure out why our SQL server is a bit sluggish from time to time. It is running a dual XEON, with 2.5 GB RAM, and a fast SCSI I/O sub system setup as follows. OS,...

Microsoft SQL Server

buffer pool hit ratio

by: eric | last post by:

Hi there, BP hit ratio = 1 - (BP physical reads / BP logical reads). If all the BP physical reads are asynchronous, it should mean that the pages are brought up to the bufferpool before the...

DB2 Database

calculate package cache hit ratio

by: xixi | last post by:

the formula for package cache hit ratio is 1 - (package cache inserts/package cache lookups), what the result would be a effective ratio? currently we have cache inserts=25, cache lookups=35, so...

DB2 Database

Package cache hit ratio

by: shterke | last post by:

Good day, I've been monitoring a DB2 system and noticed a low package cache hit ratio, I calculated it based on the formula in the db2 information center: ...

DB2 Database

estimation the buffer cache hit ratio

by: Marek Wierzbicki | last post by:

Hi I have trouble with MSSQL2000 SP4 (without any hotfixes). During last two weeks it start works anormally. After last optimalization (about few months ago) it works good (fast, without...

Microsoft SQL Server

Hit Ratio of Database Buffer Cache

by: nkumarin001 | last post by:

Hi, Anyone please answer this question Why 99%+ Database Buffer Cache hit ratio is not OK? Regards, Naveen

Oracle Database

Cache Memory Simulation problem

by: Hypnotik | last post by:

My program is to simulate cache memory. I read in the info from 2 external files, 1) access 2) data in memory. When I read the information in I display the info...and it is all correct. However...

C / C++

Package cache hit ratio,

by: Ramchandra | last post by:

Hi , i am facing problem in package cache hit ratio its between 47-45% which is very less:- here are my configuration related to package cache:- Catalog cache size (4KB) ...

DB2 Database

DB2 - forcing a table to cache all data in the buffer pool.

by: Patrick Finnegan | last post by:

Is there a DB2 setting that will force a table to be cached in the buffer pool? We have four tables that we want to cache completely in the buffer pool to ensure that all the data is read from...

DB2 Database

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General