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

Question

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

Answer 1

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://learn.microsoft.com/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.