Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005

    Unanswered: Need help with sizing named caches

    Working on Sybase 11.9.2, SMP, 6 CPus, experiencing high spinlock contention on default data cache. How can I size properly name caches? Please advise.

  2. #2
    Join Date
    Feb 2002
    Willy is on vacation
    Spinlock contetion have nothing to do withj the size of the cache. The spinlock is on the hash table in the cache. To reduce the contention, you need to partition the cache into cachlets. DO not keep the cachelets too small, this will diminish returns.

Posting Permissions

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