Report Server running code every 10 seconds 1

[ESquared]

Do you know what it's doing? Query Profiler shows the following every 10 seconds. I did a plain install and haven't changed any settings after that:

declare @BatchID uniqueidentifier

set @BatchID = NEWID()

UPDATE [Event] WITH (TABLOCKX)
SET [BatchID] = @BatchID,
[ProcessStart] = GETUTCDATE(),
[ProcessHeartbeat] = GETUTCDATE()
FROM (
SELECT TOP 2 [EventID] FROM [Event] WITH (TABLOCKX) WHERE [ProcessStart] is NULL ORDER BY [TimeEntered]
) AS t1
WHERE [Event].[EventID] = t1.[EventID]

select top 2
   E.[EventID],
   E.[EventType],
   E.[EventData]
from
   [Event] E WITH (TABLOCKX)
where
   [BatchID] = @BatchID
ORDER BY [TimeEntered]

[COLOR=#aa88aa black]Cum catapultae proscriptae erunt tum soli proscript catapultas habebunt.[/color]

 

[onpnt]

Go into your RSReportServer.config and alter the IsNotificationService to false

This is a normal routine for SSRS and there are a few more you'll notice probably if you watch it for awhile. Typically this and a few other reasoning is why it is a bad idea to put SSRS on the production server and also (and if possible) not hit the production database with SSRS. Use snapshots or such.

I found this link that seems to go over this and a few other things that may be of interest to you Reporting Services performance analysis and tuning

_{____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[onpnt]

This one should ahve a bit more knowledge and more helpful

http://msdn2.microsoft.com/en-us/library/ms157273.aspx

_{____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[ESquared]

Thank you!

[COLOR=#aa88aa black]Cum catapultae proscriptae erunt tum soli proscript catapultas habebunt.[/color]

 

[onpnt]

_{____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[ESquared]

I probably could have found that myself if I'd even bothered to search the internet, but I've been busy and, blah, whatever.

[COLOR=#aa88aa black]Cum catapultae proscriptae erunt tum soli proscript catapultas habebunt.[/color]

 

[onpnt]

I had it bookmarked. I noticed the same odd things in profiler last year when I install SSRS. It was driving me nuts so I know how you feel. There are several things by default i turn off in that config. Just make one and you can use it as a template for feature installs

_{____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}