Easy Monitor

Easy Monitor is a SQL Database metrics collection function that uses Azure Functions and Log Analytics.
Deploying from Deploy to Azure using the ARM Template will also include the Workbook, which makes metrics visible.

How to deploy

1. Deploy the ARM template from deploy to Azure.

2. Enter the required information and proceed with the deploy.

• Sql Server Name : Name of the SQL Database from which to obtain information (ex : contoso.database.windows.net)
• Database Name : Target DB
• Database Login : SQL Database Login Name If you are using Premium / Business Critical, you can create a login to the target DB by executing the following query.
  For other service levels, you cannot grant the required privileges, so you will need to connect as an administrator of the SQL Database.

  CREATE USER <Login Name> WITH PASSWORD='<Password>'
  GRANT VIEW DATABASE STATE TO <Login Name>
  

  • Max Thread : Specifies how many parallels to obtain information when the function is executed

After deployment, the Workbook for Log Analytics is deployed in the Resource group.

The information captured in Log Analytics by Azure Functions can be viewed in this workbook.

Reference information

• Deploy to Azure
  • Use a deployment button to deploy templates from GitHub repository
• Azure Functions
  • https://docs.microsoft.com/en-us/azure/azure-functions/functions-reference-powershell
  • Run your Azure Functions from a package file
• Log Analytics
  • Send log data to Azure Monitor with the HTTP Data Collector API (public preview)
  • Azure Monitor log queries
  • SQL to Azure Monitor log query cheat sheet
  • Kusto Query Language Overview
  • Azure Monitor Community Repository is now available
• Log Analytics Workbook
  • Azure Monitor Workbooks
  • Create interactive reports Azure Monitor for VMs with workbooks