Remove version ghost records of allocation type LOB_DATA without restarting the service or failing over
3
votes
1
answer
600
views
A database that is part of a SQL Server Always Availability Group with both *synchronous* and *asynchronous* readable secondaries that are being used to scale out read-only workloads is experiencing a build up of version ghost records of allocation type
LOB_DATA
.
This occurs on a table that has a high level of INSERT
operations applied to it.
REBUILD
ing the clustered index of this table removes any version ghost records of allocation type IN_ROW_DATA
but not of allocation type LOB_DATA
.
Performing a manual fail-over removes the version ghost rows, but this is undesirable.
While I am investigating the root cause of the build up of version ghost rows, is there any other way of removing version ghost records of allocation type LOB_DATA
?
Asked by afreeman
(31 rep)
Sep 13, 2021, 03:05 PM
Last activity: Sep 13, 2021, 03:58 PM
Last activity: Sep 13, 2021, 03:58 PM