sitecore reporting DB - performance
<p>we are on 8.0, Update 4.</p>

<p>Our Azure MS-SQL reporting database is showing massives performance spiking every day between 5am and 8am. We have 2 CD servers, and one CM server, the CM servers' app pool gets recycled daily at 5am, so i guess the spike is related to that. </p>

<p>This screenshot shows the query that is causing the issue, and you will notice the massive number of times that it gets run, circa 40k times over 4 hours. Does anyone know what the query is doing and how we might mitigate this? </p>

<p><a href="https://i.stack.imgur.com/KTmVv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KTmVv.png" alt="enter image description here"></a></p>