I've created a SSRS report from a SharePoint list. The list has about 65000 records. When I ran this report, all SharePoint web applications and all sites stuck on loading. After report finished executing all sites turn to normal. How can I solve this problem? Is this an infrastructure problem at our farm or something related with SharePoint? Any ideas?
P.S: I'm using SharePoint 2013 with 2 FE, 1 AP and 1 DB server.