This page has the resources for my Azure SQL Monitoring Talk
Migrating you on-premises Database to Azure SQL DB was easy but now comes the hard part how do you setup monitoring and alerts? While there are many 3rd party options, let's have a look at what comes standard with Azure:
- Using Azure Log Analytics to monitor databases
- How can you be sure your azure SQL Database isn't under or over allocated, so that your costs are optimized.
- How can you project what future costs may be.
- What tools from your on-premises SQL server toolkit will still work and what new capabilities exists.
Join this session to ensure you are getting the most out of your Azure SQL database monitoring.
The latest PDF copy of the slides: TBD
This is a link of the recorded versions of this talk in reverse chronological order
2021-10-05 SQLIreland TBD
Here are some of the resources for Azure SQL Monitoring
Description | Links |
Azure Monitor | https://docs.microsoft.com/en-us/azure/azure-monitor/overview |
Azure Alerts | https://docs.microsoft.com/en-us/azure/azure-monitor/platform/alerts-overview |
Log Analytics workspace | https://docs.microsoft.com/en-us/azure/azure-monitor/platform/design-logs-deployment |
Azure Activity Log | https://docs.microsoft.com/en-us/azure/azure-monitor/essentials/activity-log |
Azure Event Categories | https://docs.microsoft.com/en-us/azure/azure-monitor/platform/diagnostic-logs-schema |
Kusto Query Language (KQL) | https://docs.microsoft.com/en-us/azure/kusto/query/ |
KQL Examples | https://docs.microsoft.com/en-us/azure/azure-monitor/log-query/examples |
Log Analytics KQL Examples | https://github.com/MicrosoftDocs/LogAnalyticsExamples |