Releasing LOB space in Microsoft SQL Server databases

You can release the large object (LOB) storage in the Microsoft SQL Server database.

Before you begin

Plan downtime for upgrading HCL DevOps Deploy (Deploy) and releasing LOB space.

About this task

Release LOB storage for Microsoft SQL Server database using the following steps:

Procedure

  1. Set the versioned_config.upgrade.enabled=true parameter in the conf/server/installed.properties file.
  2. Restart the Deploy server.
  3. Check on the progress of the conversion:
    select count(*) from vc_persistent_record where persistent_data is not null

    The compression process is complete when the row count reported by the query is 0.

  4. Check the database size:
    EXEC sp_spaceused @updateusage = N'TRUE';
  5. Compress the database table:
    DBCC SHRINKDATABASE (dbname, 0);
    DBCC SHRINKDATABASE (dbname);

What to do next

  1. Verify that the space is reduced:
    EXEC sp_spaceused @updateusage = N'TRUE';
  2. Set the versioned_config.upgrade.enabled parameter back to false in the conf/server/installed.properties file.