Procedure Cache and Buffer cache

Question

Procedure Cache and Buffer cache

Narine M

SSCrazy

Points: 2672
More actions
October 27, 2016 at 10:53 am

#331446

Can any one explain the difference between buffer cache and procedure cache with example..

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Eric M Russell SSC Guru Points: 125521 More actions · Answer 1

The buffer cache contains data and index pages. For example, logical reads are from buffer cache while physical reads are from disk.

The procedure cache contains query execution plans.

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Narine M SSCrazy Points: 2672 More actions · Answer 2

Eric M Russell - Thursday, October 27, 2016 11:10 AM
The buffer cache contains data and index pages. For example, logical reads are from buffer cache while physical reads are from disk.The procedure cache contains query execution plans.

Thank you

Narine M SSCrazy Points: 2672 More actions · Answer 3

Narine M

SSCrazy

Points: 2672

January 24, 2017 at 12:07 am

#1924526

Then how about plan cache?

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 4

Narine M - Tuesday, January 24, 2017 12:07 AM
Then how about plan cache?

The plan cache is the same as the procedure cache.

Narine M SSCrazy Points: 2672 More actions · Answer 5

NorthernSoul - Tuesday, January 24, 2017 6:13 AM
Narine M - Tuesday, January 24, 2017 12:07 AM
Then how about plan cache?
The plan cache is the same as the procedure cache.

Thank u