Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    23

    Unanswered: Increasing data cache size

    We have a sybase 12.5 server running on SUN Sparc.. The "max memory" is set to 500 MB but the logical and physical memory are still at 70M each.

    The data cache size is about 8M (sp_helpcache ouput).

    Can anyone please let me know how I could increase the size of the data cache. I would like it to be about 300 M atleast.

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Code:
    exec sp_configure "max memory", 256000 
    go
    exec sp_cacheconfig "default data cache", "300M"
    go

  3. #3
    Join Date
    Mar 2003
    Posts
    23
    Thanks !!!... I could get through that.. I am intrigued by the low values of the total logical and physical memory.

    How could be bring about a change in the same ?

Posting Permissions

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