SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
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.
What you describe sounds like you have issues with a table lock. Table locks happen if you retrieve to many items from a sharepoint list. This is usually prevented by the list throttling feature.
Do you have turned that feature off since you need to bypass it for that list?
SQL will promote row locks to a table lock at 5000 items. When this happens everyone (in that database) needs to wait till the table lock is done.
You can lessen your pain by moving your site into its own SQL-DB, which it should not share with any other site collection. The best option of course is to only retrieve fewer records ;)
(edit) : Fixed an error in the reply
