June 13, 2002 at 1:12 am
Is it common at other sites to have some tables pinned?
I see the performance improvement when you can have some quite small but often referenced tables data loaded into the buffer cache.
What shall we think about if we want to use it?
Does it work even if the whole table is reloaded from another server every night?
Do you have any experience to give me I would be grateful.
AW
Edited by - BG0AWI on 06/13/2002 01:13:56 AM
AW
June 13, 2002 at 3:25 am
Hi
I have 4gb ram on my box, and have pinned 290Mb data (37 tables of 300 in the schema and 800,000 rows)... watch your buffer cache for variences with hit ratios and monitor issues with buffers being stolen. These tables are hit heavily and used for a bulk of the searches and lookups against the database. So from that, you need to gadge your requirements and pick tables where you get maximum bang for your buck. Remember that pinning doesnt mean that the pages will never be repaced from the buffer cache, they are just "less likely" to be based on its aging algorithm.
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply