Highlighted
Micro Focus Expert
Micro Focus Expert
110 views

(UCMDB SUPPORT TIP) - SQL Server Issues Due to Space - high number of records in sync_id_map

Issue:

Is it  possible to drop the sync_id_map table to resolve space issues piece by piece or there are mandatory relations in this table to other tables ?

 

Workaround:

1) It is ok to drop only that table piece by piece and should not affect other tables . Typical SQL would be :

DELETE top(1000000) FROM [dbo].[SYNC_ID_MAP] WHERE DS_ID = 22
SELECT COUNT(*) FROM [dbo].[SYNC_ID_MAP]

2) Also if a customer is using the Full Recovery model in their database setup , the transaction logs could be taking up a lot of the space. ? Ticking the "Truncate the transaction log" check box on the Back Up Database screen of the MS SQL GUI could help here .
Please note that all deletions and truncations are the responsibilty of the customer and any truncations or deletions must always be preceeded by a full , easily - recoverable database backup.

MICRO FOCUS Software Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Please hit the Kudo botton, if you find this post useful.
Tags (1)
0 Likes
0 Replies
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.