SharePoint throttling prevention
This feature is available in KONNEKT 2.2 or newer
The usage of Microsoft 365 APIs is subject to limitations in terms of the amount of requests per time, that an application may send. If an application uses more resources, it will be throttled. You can find more on this in the Microsoft docs.
Since KONNEKT is using Microsoft SharePoint Online REST API and Microsoft Graph API, it may happen, that Microsoft APIs will throttle your KONNEKT usage. If an application is throttled, the corresponding API (e.g. SharePoint Online REST API) tells KONNEKT, that it has to wait for a defined amount of time. This starts from some seconds and can grow up to minutes, depending on the usage. Impacts for KONNEKT may be slow browsing through or loading/writing of files. If the throttling grows up to minutes, it will result in error messages that the drive is currently not available.
KONNEKT has several mechanisms to reduce the occurrence of throttling, which are applied automatically. There are other settings, that you can decide on, since this will affect the timeliness e.g. of new libraries or files being available in KONNEKT. Please take a look at the following policy to learn about the available options.
In heavy load environments, all measures may not be enough to prevent throttling.
KONNEKT was made for regular office work. If you use high volume files (e.g. video editing, graphics design, CAD) or read/write gigabytes of data, KONNEKT (& SharePoint Online) may not be the proper tool of choice.
The following circumstances promote throttling:
- Usage of 3rd party tools for SharePoint Online backup - especially during working hours
- Use of tools that crawl your whole filesystem (like preview renderer etc.)
- Use of very big folders with >1000 files on the first level of the folder
To avoid this, please
- Do not run backups of SharePoint online during working hours.
- Do not use any preview renderer for KONNEKT resources. See also here. You can additionally set the Offline Filter to the file extension "YYY" (which does not exist), to prevent Windows File Explorer from rendering previews for PDF files.
- Segment your data (not too many files in the first level of a folder).
- Set KONNEKT SharePoint Throttling Prevention Policy (see below) to "High"
When you turn the KONNEKT logging to "debug", you will see log entries with "
Throttling detected: 429 Retry-After X" (where X stands for the amount of seconds SharePoint Online wants us to wait).Log entries that contain "
ThrottledRequest:" are NOT caused by SharePoint throttling. Those indicate regular operations - nothing to worry about. ;-)Policy Name (GPO & Intune):
Sharepoint Throttling PreventionAvailable settings:
EnabledAutodetect(default) KONNEKT will decide on active measures.LowThrottling prevention takes place in case of throttling events, only.MediumMore data is cached than in Low to prevent unnecessary requests to SharePoint Online.HighThrottling prevention has the highest priority. Some changes from other clients (e.g. new libraries or new files/folders) may be updated late (up to 24 hours).
DisabledDefault Throttling Prevention takes place
SharePoint Online monitors throttling on several levels. From our experience the tenant level is the most important one for KONNEKT.
Because of that, throttling prevention becomes effective, if ALL KONNEKT clients in your tenant use the same prevention level. For example: Just setting this policy to "high" on some clients may have no effect at all. Please set all to "high", if you experience throttling while using KONNEKT.
You do not need this, if you use GPO or Intune management.
- Value name:
SharepointThrottling - Value type:
REG_DWORD - Value data
0=> Autodetect (default)1=> Low2=> Medium3=> High
- Value stored in:
HKEY_CURRENT_USER\SOFTWARE\Policies\GlueckKanja\KonnektorHKEY_LOCAL_MACHINE\SOFTWARE\Policies\GlueckKanja\Konnekt
Last modified 5mo ago