Azure database performance degraded with 100% DTU usage and showing additional tables and stored procedures

Viewed 17

We are having issues with one of Azure database where the DTU is hitting 100% almost at all times.

DTU Percentage is showing max

This is causing connection failure when some other applications are trying to connect with the database as database is taking to long to respond to create a connection and the connection is timing out.

We had a quick look at the schema and could see that some tables and stored procedures which are not created by us are somehow generated. On modifying these procedures, we find out that some of these are running and appearing in high execution queries list. I am pasting the screenshot of these tables and SPs here. Does anyone know how these are created/auto generated in the database and if these are auto generated, there is a way to find out which application has created and executing these? Stored Procedures

Tables

0 Answers
Related