October 9, 2002 at 1:14 pm
SQL Server 2000:
What is the size of one Buffer?
Is the buffer size the same for the Buffer Cache and Procedure Cache?
October 9, 2002 at 5:07 pm
Not sure what you are asking here as buffers are most likely dynamically sized to make best use of memory. Also, many are built by the server not just 1. The you take about the Buffer Cache and Procedure Cache, to the best of my knowledge these are actually collection of buffers which buffers are nothing more than memory set to a data value inside a variable and between the caches they are constantly changing and resizing.
Just as an example if you happen to know anything about C image I create a variable
char chVal
well I have to assign the variable a size for data storage so I do
char chVal[2048]
which the 2048 is the number of bytes of storage the variable contains. Now with that in mind I can store up to 2KB of data in memory assigned to that variable, thus I have a buffer of 2KB to store, manipulate and free data within.
There are tricks you can use to resize this space as needed. But just in basic terms a buffer is an amount of memory used for data storage and manipulation.
Hope this helps.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 9, 2002 at 10:08 pm
The reason I am asking is because I am doing some performance testing.
I want how to get the size of the Buffer cache and procedure cache at any point in time.
Also, in Perormance Monitor, the Object:
SQLServer:Buffer Manager
Reserved Pages
(Number of buffer pool reserved pages.)
What size are these pages?
Are these Memory pages?
Databases pages?
October 10, 2002 at 12:45 am
Hi Bryan99,
Please visit "http://www.sql-server-performance.com/rd_data_cache.asp"
Hope this is what you are looking for.
Cheers
Gopi
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply