question

SergioSolorzano-2873 avatar image
0 Votes"
SergioSolorzano-2873 asked SergioSolorzano-2873 commented

Where Azure SQL Database logs for failed Data Manipulation SQL queries?

I can find tools in Azure to monitor and get logs on the performance of an Azure SQL database.

However, what tools are available in the Azure portal to see logs of failed SQL data manipulation queries for the database? - e.g. update, delete, insert queries?

Thank you


azure-database-mysql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @SergioSolorzano-2873 Welcome to Microsoft Q&A and Thank you for posting your question. We are looking into this and will get back shortly. Thanks

0 Votes 0 ·

1 Answer

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered SergioSolorzano-2873 commented

Hello @SergioSolorzano-2873 Please go through the article to know about capturing the logs using extended events.

Please let us know if that helps.

Regards,
Oury

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for your help @OuryBa-MSFT

0 Votes 0 ·