How to install MSSQL Database on Windows virtual machine and enable monitoring on it

Jagannath Ojha 0 Reputation points
2024-12-12T15:22:40.18+00:00

mssql database setup and monitoring

I want to set up MS Sql database and enable database monitoring against it.

Please guide me with the procedure

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
874 questions
{count} votes

1 answer

Sort by: Most helpful
  1. SUNOJ KUMAR YELURU 14,871 Reputation points MVP
    2024-12-12T16:51:55.8333333+00:00

    Hello @Jagannath Ojha

    Thanks for using Q&A forum.

    Refer to the doc and follow the steps- deploying your SQL Server on Azure Virtual Machines (VMs) by using the Azure portal.

    • To enable monitoring
           [Enable diagnostics settings for the VM](https://zcusa.951200.xyz/en-us/azure/azure-sql/database/monitor-tune-overview?view=azuresql?WT.mc_id=AZ-MVP-5005118)
      
           Create an alert rule
      

    Monitor Azure SQL Database with metrics and alerts


    If the Answer is helpful, please click Accept Answer and Up-Vote, so that it can help others in the community looking for help on similar topics.


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.