persistent variable table size

Unanswered Question
Feb 24th, 2009

Hi


I looked at my table size on my logger. The table t_Persistent_Variable have 16 only 16 row but take 475Mb of the database. I do a SELECT to check the data and I'm sure that those 16 row cannot occupied 475Mb of the databas. Is there something that I can do to clean some space from that particular table.


Regards

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4 (1 ratings)
Loading.
irisrios Mon, 03/02/2009 - 08:22

The Persistent Variable table is unlike the other historical tables. The other tables have date/time entries that indicate historical data. Persistent Variable, on the other hand, only contains one record for each variable that is persisted, which contains the current value. The PV table may be updated frequently, depending on the usage of the variables. The frequent updates may cause fragmentation, which could possibly be the cause of the table taking up a lot of space. HKEY_LOCAL_MACHINE\SOFTWARE\Cisco Systems, Inc.\ICM\li102\LoggerA\Recovery\CurrentVersion\Purge\Retain\Variables\Persistent could be reduced from 30 to lesser days if the data being populated is too frequent.


Actions

This Discussion