AnsweredAssumed Answered

SQL Database purging / cleansing

Question asked by RutvikkumarMrug on Apr 8, 2014
Latest reply on Apr 8, 2014 by DanPerovich

Hi,

We have currently LISA registry in UNIX server which connects to SQL server DB. During recent time, It seems our DB has consumed all available space. I have done below but it doesnt seem to working. Can anybody help me in this?

# These properties control how often old metric data is scanned for and deleted, along with what counts as old.

lisa.vse.metrics.delete.cycle=1h

lisa.vse.metrics.delete.age=30d

As per my understanding, we should have by default data purging happening. However as we are still getting issue, Is below stuff not working? How can we verify that? Also, Is this parameter purges / cleansing data only for VSE or all (incl ACL, registry, etc...)? Any other thoughts which can help us in preventing issue?

 

Thanks,

Rutvik

Outcomes