Return
-
Title
DELETE statement growing Transaction Log statistics repository -
Description
After upgrading to Spotlight on SQL Server Enterprise from 7.x to 8.01, there are sudden transaction log increases (GB's in a few minutes).
Running a trace reveals several DELETE TOP(500000) statements on the spotlight_perfdata and spotlight_timestamps tables in the SpotlightStatisticsRepository database.Is this a change from the previous version and is there a way to limit or configure this setting?
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.