November 30, 2015 at 6:46 am
I'm hoping someone might be able to offer some inspiration into a problem I'm seeing with a reports. I'll start by giving some context:
We are migrating from CRM 2011 to 2015 and DB from SQL 2008 r2 to SQL 2014
When we execute any of the reports from CRM we are seeing blockings on the server
SSRS is on one server: http://dev1/Reports
Report server and CRM db is on another server: dev2
CRM is on another server: dev3
We are seeing that ReportServer.dbo.GetSessionData;1 is getting blocked by ReportServer.dbo.WriteLockSession;1.
Some times we are getting time puts when we eecute multiple reports at a time
Can some one please help me solve this
November 30, 2015 at 9:01 am
Improve the performance of the query\report ie add indexes\rewrite etc. Look into the execution plan of the problematic query.
November 30, 2015 at 9:09 am
From my understanding the blocks in the reports DB is just the recording of report executions etc. In my experience long running reports cause this issue. Identify all long running reports and performance tune.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply