Now that I have cranked my data cache up to 1.3 GB, I am trying to figure out the optimal configuration for my 2K, 4K and 16K buffer pools. We have both OLTP an DSS on our system and it is about half and half. Anybody have some good ideas to start with?
1) create 2 new data caches : tempdb_cache and log_cache
2) bind tempdb in tempdb_cache and add a buffer pool of 16K and 4K (for log)
3) add a max buffer pool of 4K for log_cache and bind it all logs of all databases (don't forget model)
2) Add a buffer pools of 16K for the default data cache