Initially we thought this would be normal because of the huge number of users we served in combination with a retention time of 90 days. It took us several days to cleanup almost 550 million records of Sampling mode data from dbo.tblLogs (delete from dbo.tblLogs where lngClassId = 48). Soon as all Sampling mode data was deleted we reanalysed the logging database again, but found it was still quite large. This time we noticed several components, like “General Errors Log” & “User Event Logs : Session Refresh” were consuming lots of database space. HOWTO: Clear certain entries from the tbllogs table in an Ivanti Workspace Control Database Ivanti has an extensive support article, which describes how to clean specific type of records from the tbllogs table. The console crashed repeatedly and wasn’t able to do the cleanup anymore.ĭeleting the records can be done with the Workspace Manager Logging Management Tool, but the amount of records was so much we decided to run all cleaning on the SQL server itself. Sampling Mode was by far using most space within our logging database. Initially we tried to delete the Sampling Mode data from within the Ivanti Workspace Control Console, but there was just to much data. The tool was created by a former employee Patrick van Grinsven. Soon it became clear what exactly was using so much space within the logging database. We contacted Ivanti Support to investigate the huge increase in logging database size. They told me about a useful tool called “ Workspace Manager Logging Management Tool“. During regular maintenance at a customer we noticed the Ivanti WorkSpace Control logging database was getting quite big. The logging database had reached a size of more than 1TB, something of which the cause was not immediately clear. Sure they had lots of users and were keeping lots of auditing data, but the increase in database size couldn’t be related to additional users or something else.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |