-> Azure SQL Analytics uses Azure log Analytics and provides several reports with regards to Azure SQL tasks and performance. It supports below Azure SQL resources,
- Azure SQL Elastic Pools
- Azure SQL Databases
- Azure SQL Managed Instance and databases
-> Let’s setup Azure SQL Analytics and check using below steps.
-> Click “Create a resource”, type “Azure SQL Analytics” and select it.
-> Once you click “Create”. You will be advised to select an existing Log Analytics Workspace or create a new one. In our case, I will be creating a new Log Analytics Workspace,
-> Azure SQL Analytics is created. Now data should be sent to Log Analytics workspace.
-> All Azure SQL resources like Azure SQL Managed Instance, Azure SQL Database or Elastic pool can be configured to send its data to Log Analytics workspace by configuring “Diagnostic settings” under “Monitoring” section.
- Azure SQL Managed Instance
-> Open appropriate Azure SQL Managed Instance from Azure portal. Click “Add diagnostic setting”,
1.1 Azure SQL Managed Instance Database
-> Open Azure SQL Managed Instance database from Azure portal. Click “Add diagnostic setting”,
2. SQL Elastic Pool
-> Open SQL elastic pool from Azure portal. Click “Add diagnostic setting”,
3. Azure SQL Databases
-> Open required Azure SQL database from Azure portal. Click “Add diagnostic setting”,
-> Let us try opening Azure SQL Analytics and check what details we have.
-> Open “Log Analytics Workspaces”,
-> Click on “Workspace Summary” and you will see below screen,
-> Click on “Azure SQL databases” and you will get details collected so far,
-> Click on “Resources per utilization Bucket” and you will see more details,
-> You can modify queries to get more details,
-> Now details for “Azure SQL Managed Instance”,
-> You can get more details from this solution that would give you some good information to complete a health check of Azure SQL database or managed instance
Thank You,
Vivek Janakiraman
Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.