Resource Manager template samples for SQL Insights (preview)

This article includes sample Azure Resource Manager templates to enable SQL Insights (preview) for monitoring SQL running in Azure. See the SQL Insights (preview) documentation for details on the offering and versions of SQL we support. Each sample includes a template file and a parameters file with sample values to provide to the template.

Note

See Azure Resource Manager samples for Azure Monitor for a list of samples that are available and guidance on deploying them in your Azure subscription.

Create a SQL Insights (preview) monitoring profile

The following sample creates a SQL Insights monitoring profile, which includes the SQL monitoring data to collect, frequency of data collection, and specifies the workspace the data will be sent to.

Template file

View the template file on git hub.

Parameter file

View the parameter file on git hub.

Add a monitoring VM to a SQL Insights monitoring profile

Once you have created a monitoring profile, you need to allocate Azure virtual machines that will be configured to remotely collect data from the SQL resources you specify in the configuration for that VM. Refer to the SQL Insights enable documentation for more details.

The following sample configures a monitoring VM to collect the data from the specified SQL resources.

Template file

View the template file on git hub.

Parameter file

View the parameter file on git hub.

Create an alert rule for SQL Insights

The following sample creates an alert rule that will cover the SQL resources within the scope of the specified monitoring profile. This alert rule will appear in the SQL Insights UI in the alerts UI context panel.

The parameter file has values from one of the alert templates we provide in SQL Insights, you can modify it to alert on other data we collect for SQL. The template does not specify an action group for the alert rule.

Template file

View the template file on git hub.

Parameter file

View the parameter file on git hub.

Next steps