Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2013
    Location
    Bangalore
    Posts
    30
    Provided Answers: 2

    Unanswered: Swap Space Memory is not Released - Sybase IQ 16.0 sp04.04

    Hi All,

    We are using Sybase IQ 16.0 and facing DB performance issues often.

    Swap memory is 150 GB and Data volume is 3.5 TB. Whenever Complex reports are running swap is consumed heavily around (50 GB) .

    Post Execution swap space is not released to the DB. As of now we are going for DB restart every alternate days.

    Do anyone knows how to avoid this and clear the swap space, Please help....
    Yuvaraj Subramani

  2. #2
    Join Date
    Nov 2016
    Posts
    3

    Lightbulb

    if complex reports have complex queries that consume more temp cache, you can give more scpace to temp cache.

  3. #3
    Join Date
    Nov 2013
    Location
    Bangalore
    Posts
    30
    Provided Answers: 2
    Moved out from that Client and now in New workplace . Thanks for the info buddy !!!
    Yuvaraj Subramani

Posting Permissions

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