This content has been marked as final. Show 2 replies
Read this link for cache settings.
For data cache :
0.125 * the value of data file cache size. Increase value if any of these conditions exist:
1.Many concurrent users are accessing different data blocks.
2.Calculation scripts contain functions on sparse ranges, and the functions require all members of a range to be in memory (for example, when using @RANK and @RANGE).
Edited by: Sundeep on Jan 5, 2012 1:05 PM