unexpected high load on SQL backend (SharePoint 2016)

New Contributor

Hi,


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:


proc_GetTpWebMetaDataAndListMetaData

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

Sven

0 Replies