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
