Activity overview
Latest activity by johnzabroski
To follow-up here, we've been experiencing this problem on our largest database. Anecdotally, the problem seems to occur once databases cross the 1 TB threshold. The other problem I see is that RedGate SQL Clone Agent does not log when the image is finished building, only when its creation started. In fact, for all my images, if I query the SqlClone_Config database directly, the State of the operation is 4 (Successful), but we don't know WHEN the Operation changed its state to Successful. SELECT * FROM dbo.Images i JOIN dbo.Operations o ON i.Id = o.ImageId WHERE i.DeletedOn IS NULL Separately, if I reset a Clone, it starts off at 44.1 MB, then goes to 381 MB, then goes to 17.0 GB…. and then 38 GB… all without me doing anything? I can record a video of this happening. I can also run SQL Profiler to demonstrate nothing is happening to the clone I reset. I also took my own suggestion to RandyBCD 6 years ago, and checked for index writes. There are none. / comments
To follow-up here, we've been experiencing this problem on our largest database. Anecdotally, the problem seems to occur once databases cross the 1 TB threshold.The other problem I see is that RedG...