DeleteExpiredSystemObjects bug? RRS feed

  • Question

  • This stored procedure is run periodically by a SQL Server Agent job to prevent the database from growing too large and keeping FIM responsive.

    BUT... What the procedure is doing is to delete all attributes on the objects in the database and leaving the main table [fim].[objects] to continue growing. ( The table [fim].[ObjectValueIdentifier] also has this behavour and doesen't get deleted from. )

    In our database, with a total of 24 454 388 objects, 7 707 052 seems to be "deleted" objects. Doing a standard "Disk usage by Top Tables" report, [fim].[objects] and [fim].[ObjectValueIdentifier]  is in top five.

    Is there a reson why old expired objects with no attributes should/must remain in the database?

      / Jörgen

    Tuesday, October 27, 2015 11:41 AM