Share via

SQL server logs in azure

MrFlinstone 541 Reputation points
2022-09-09T12:04:19.297+00:00

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee
    2022-09-09T20:38:41.907+00:00

    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.
    239683-image.png
    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.

    Regards
    Geetha

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.