Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: buffer pool configuration

    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?

  2. #2
    Join Date
    Nov 2002
    To begin:

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts