December 5, 2001 at 11:45 am
Has anyone used pintable before? what was
the result?
thanks
December 5, 2001 at 11:53 am
I used it with a couple small lookup tables. On our server, it didn't really provide any noticable difference.
Steve Jones
December 5, 2001 at 4:27 pm
I have not - wouldnt expect to matter unless you were memory constrained and it was getting dumped out of cache a lot - which shouldnt happen if its being used very often anyway.
Andy
December 6, 2001 at 6:22 pm
I use it quite a bit and have noticed a small benefit. I have a range of security lookup tables etc and various reference data tables that I pin (total of 10mb!) to keep them in the buffer cache between larger reporting type queries. The benefit is hard to measure but if you have a lot of ram, pin them and keep a eye on your hit ratio and reads.
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply