6

As I understand SharePoint resource throttling for large sets of items was introduced in SP2010 to safeguard against SQL table locks by massive queries from SharePoint. I have 2 questions about this resource throttling:

  1. Are there major (or any at all) changes in resource throttling implementation (default values, the way it is enforced) between SP2010 & SP2013?
  2. Doing some test in SharePoint 2013 I noticed that when I create list with 5000+ items I don't see threshold being enforced, but at the same time when I create a library with 5000+ directories it is being enforced. Why is it so?

Can somebody confirm that/share links to documentation which explains this?

1 Answer 1

4

There has not been any major changes to the throttling rules. Things are still set to 5000 items returned unless Admin or certain times (if enabled). You still are limited to the default 8 lookups. Basically the settings and how they are enforced hasn't changed.

I have honestly never heard about thresholds not being enforced on a single box installation. I wouldn't know why you would want to build something that large on a single box anyways. They only time I have ever used it is for demos and even then, I make sure I have a large enough system to handle a separate SQL server from SP. If you are hitting the kinds of queries and number of items that start hitting thresholds, you should consider moving to a different architecture.

You aren't using this in a multi-user environment are you?

8
  • 1
    Thanks for your response. I'm basically using single test VM which includes almost full MSFT stack in it (Windows Server, SQL, Exchange, SharePoint) and I'm unable to get threshold enforced on this box. I'm creating 5000+ elements list, using regular, non-admin user but anyway user not getting threshold enforcement message...
    – Mikhail
    Dec 16, 2015 at 13:22
  • That's interesting Mikhail. I have honestly never heard of that. Dec 16, 2015 at 13:23
  • Also default list view lookup threshold seems to be increased to 12 in SharePoint 2013 Post June 2013 CU update... I seen this mentioned in SharePoint Escalation Services Team Blog.
    – Mikhail
    Dec 16, 2015 at 13:24
  • You learn something new every day. I didn't know that. I can confirm as we are on Oct 2015 and set at 12. As for your threshold checks, are you doing this while logged in as an admin? Admins have a default threshold of 20000. Dec 16, 2015 at 13:31
  • I was logged as admin but I used runas for IE with regular user account...
    – Mikhail
    Dec 16, 2015 at 14:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.