unexpected high load on SQL backend (SharePoint 2016)

Copper Contributor


we noticed high load on the SQL Backend of the SharePoint 2016 environment. After a quick analysis we found out that the following stored procedure is called up to 400 times per second:


MS Docs says:

The proc_GetTpWebMetaDataAndListMetaData stored procedure is called to retrieve metadata for a particular site or list.

The environment's concurrent user amount is not higher than 500.

Is this behaviour normal? What can be done in regards to further troubleshooting?

Best Regards


0 Replies