Hi All,
For the last 2 weeks we are facing an issue in Solarwinds specifically on Thursday & Friday. By Friday morning we used to get alert from DB server that transaction logs are full. While checking the DBA team found locks in the database. My DBA told that the Solarwinds started running an update (query given below) from Thursday evening and that blocked large number of queries. Once the SW services are started things will be back to normal.
Can any one help me to understand what can be the reasons for this issue.
(@ID int,@DisplayName nvarchar(1000),@Value float,@Unit int,@Status int,@OriginalStatus nvarchar(1000),@Message nvarchar(4000),@IsDeleted bit,@IsDisabled bit)
UPDATE dbo.HWH_HardwareItem
SET [DisplayName] = @DisplayName
,[Value] = @Value
,[Unit] = @Unit
,[Status] = @Status
,[OriginalStatus] = @OriginalStatus
,[Message] = @Message
,[HasHistoricalData] = CASE WHEN HasHistoricalData = 1 OR @Value IS NOT NULL THEN 1 ELSE 0 END
,[IsDeleted] = @IsDeleted
,[IsDisabled] = @IsDisabled
WHERE ID = @ID
@aLTeReGo @mesverrum @rschroeder @bobmarley Any help pls
