Sample Header Ad - 728x90

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. REBUILDing 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