Does anyone have any advice on how I should start tuning this thing?

Dwilkie 2016-11-07 18:30:40

This was taken from an SSRS report created by a 3rd party vendor.

Vlady Oselsky 2016-11-07 19:31:11
Step 1. Run it in Plan Explorer to collect important information including actual cost and duration.
Step 2. Upload new plan generated by plan explorer to provide much-needed information to properly diagnose the issue and propose a solution.