var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Swap Space Memory is not Released - Sybase IQ 16.0 sp04.04
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....
if complex reports have complex queries that consume more temp cache, you can give more scpace to temp cache.
Moved out from that Client and now in New workplace . Thanks for the info buddy !!!