I have current and several historical db's.
What is the best way to share cache among them ?
Is it better to have one large cache or divide it into the named one and
default cache.
For example named cache for current and default for historical ones ?
Does anybody have experience with named microcaches for separate tables
or indexes ?

--
My best regards,
Vitaly Lipovetsky.
Deputy head of IT division
First Ukrainian Intl bank

Brainbench(Tekmetrix) e-certification id 14050 SYBASE DBA 4.38
Brainbench(Tekmetrix) e-certification id 14050 MS SQL Server DBA 4.51