No data appear in the historical lock data, when looking at lock older than few days.
“No locks took place during the specified time range” appears in the historical lock area
Historical Lock data would be purged after 3 days due to the default retention policy that is in place.
For the table you should increase the following retention policies:
You should also increase the following retention policies:
If PA is installed you also have to increase the following retention policy:
DBO_PA_Locks_History_Tree_Data
