Custom logs for SQL databases running on Azure VM

Nikhil Verma 40 Reputation points
2024-06-26T06:51:51.8433333+00:00

Hi , I would like to capture the databases health and some other basic SQL databases configuration related to health and send them to Log analytics agent . This is specific to SQL Databases running on Azure SQL VM . What would be right approach to push this information to the Log analytics agent .. Custom Logs ? / Writing events to Event viewer

?

Any pointers will be appreciated..

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,318 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
    2024-06-26T19:04:53.09+00:00

    @Nikhil Verma Thank you for reaching out.

    The recommendation is to use database watcher but this currently supports SQL DB and SQL MI. Support for SQL VM is planned but we don't have an ETA for now to share with customers.

    For Azure SQL on VM, Unfortunately, we do not have a recommended solution at this time.

    Regards,

    Oury