SQL server logs in azure

MrFlinstone 441 Reputation points

I would like to know if Azure has SQL server style logs to view connection drop outs, general errors, server health etc.

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 21,396 Reputation points Microsoft Employee

    Hi, @MrFlinstone Thanks for posting your question in the Microsoft Q&A forum.
    As we understand the ask here is you want to view server logs for connection dropouts and general errors.

    Azure SQL Database does not provide a log similar to SQL Server error log (which doesn't include all connection drop events at any rate).
    Some of this is exposed via metrics and DMVs. Extended Events to monitor logins, as well as Log Analytics and Resource Health are exposed in the portal on a separate page.
    One option for you to consider is sys.database_connection_stats - Azure SQL Database | Microsoft Learn.

    Please let me know if you need any additional information.