I've been doing some monitoring on one of our SSRS servers and have picked up a dead lock that occurs every morning at 2am, the victim and the deadlocking process are both the system created stored procedure 'dbo.CleanExpiredServerParameters' in the ReportServer database.
I can see that this is removing expired parameters but what I am having trouble determining is what is calling this, we have nothing running at 2am so this must mean that the SSRS instance itself is running this, does anyone know about this procedure? Or how I may be able to resolve the deadlock.
The procedure is running the following code;
CREATE PROCEDURE [dbo].[CleanExpiredServerParameters]
@ParametersCleaned INT OUTPUT
DECLARE @now as DATETIME
SET @now = GETDATE()
DELETE FROM [dbo].[ServerParametersInstance]
WHERE ServerParametersID IN
(SELECT TOP 20 ServerParametersID FROM [dbo].[ServerParametersInstance]
WHERE Expiration < @now
SET @ParametersCleaned = @@ROWCOUNT
I've not had much luck in finding anything about it.
Any help you can be would be gratefully appreciated.