This is a revisit of a previous issue we had. See this post for reference:
Having installed Continua v188.8.131.527 only a few days ago, our DB Administrator is reporting the same issue we had before.
Same story as before: they have an open (and sleeping) transaction where they keep doing some update/insert and never close it. Tempdb will fill and prod will die eventually.
You can send them this code:
(@p0 nvarchar(128),@p1 nvarchar(128))select serverprop0_.Id as id1_18_, serverprop0_.Namespace as namespace2_18_, serverprop0_.Name as name3_18_, serverprop0_.Value as value4_18_, serverprop0_.CollectedValue as collectedvalue5_18_, serverprop0_.ElementType as elementtype6_18_, serverprop0_.IsUserSupplied as isusersupplied7_18_, serverprop0_.ReadOnly as readonly8_18_, serverprop0_.Description as description9_18_, serverprop0_.CollectorId as collectorid10_18_ from core_serverproperty serverprop0_ where serverprop0_.Namespace=@p0 and serverprop0_.Name=@p1 ORDER BY CURRENT_TIMESTAMP OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY
He also comments:
…also as before, RCS is turned off for their DB until fixed by them. Unless we get blocking with builds, maybe we just keep it off.
Can you please look into this?