How to Set up Azure Monitor for SQL Insights | Data Exposed

preview_player
Показать описание
SQL insights is a comprehensive solution for monitoring any product in the Azure SQL family. Learn about how to set up Azure Monitor for SQL insights with Alain Dormehl, Senior Program Manager at Microsoft.

0:00 Introduction
1:00 Azure Monitor SQL insights overview
3:06 Documentation
3:40 Set up storage - Log Analytics Workspace
4:52 Set up a virtual machine
7:22 Set up a user
14:30 Getting started

✔️ Resources:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQLInsights #SQLInsights #AzureSQLAnalytics #AzureSQL #DataExposed
  1. Microsoft Developer
  2. Microsoft
  3. Developer
  4. SQL Insights
  5. Azure Monitor SQL Insights
  6. Azure SQL
Рекомендации по теме
How to get 0:03:31

How to get started with Azure Virtual Desktop | Azure Tips and Tricks

Azure Virtual Desktop 0:24:33

Azure Virtual Desktop Setup Made Easy - Step-by-step Guide

Creating a Azure 0:27:43

Creating a Azure Cloud Server: A Step-by-Step Tutorial (IaaS)

Learn to setup 0:07:24

Learn to setup a free Microsoft Azure account for learning Azure!

How to setup 0:07:11

How to setup your Azure Subscriptions the right way

Complete Guide to 0:18:27

Complete Guide to Setting up Azure Virtual Desktops

Setup an Azure 0:05:38

Setup an Azure Virtual Machine in JUST 5 minutes - Tutorial

Azure Virtual Desktop 0:09:14

Azure Virtual Desktop | Quick Setup

.NET Microservices in 0:49:52

.NET Microservices in Azure Container Apps

Set Up Microsoft 0:07:44

Set Up Microsoft Azure SQL Server and SQL Database (Step-By-Step Tutorial)

Learn Microsoft Azure 0:38:05

Learn Microsoft Azure Active Directory in Just 30 Mins (May 2023)

Deploy Azure virtual 0:10:53

Deploy Azure virtual machines

Azure Active Directory 0:08:18

Azure Active Directory | Azure Active Directory Tutorial | Azure Tutorial For Beginners |Simplilearn

How to create 0:03:23

How to create a free Microsoft Azure Account

How To Create 0:10:50

How To Create Azure Account | Azure Account Creation | Azure For Beginners | Intellipaat

Azure Virtual Machine 0:14:30

Azure Virtual Machine Tutorial | Creating A Virtual Machine In Azure | Azure Training | Simplilearn

Azure Active Directory 0:30:57

Azure Active Directory (AD, AAD) Tutorial | Identity and Access Management Service

Build your first 0:17:02

Build your first Web App with Microsoft Azure

How to Create 0:09:04

How to Create a Virtual Machine in Azure Portal Free - Step by Step

Host a Website 0:05:03

Host a Website on Azure Tutorial

How to set 0:02:02

How to set up authenticator on a new phone | Azure Active Directory

Creating your first 0:44:01

Creating your first Azure VM!

Azure Installation Windows 0:06:24

Azure Installation Windows Server 2019

Azure Site-to-Site VPN 0:08:01

Azure Site-to-Site VPN quick setup

Комментарии
Автор

Great to see all the advancements made, enabling to customise the troubleshooting and monitoring capabilities. Something DBA's can sink their teeth into.
That said, the existing "Azure SQL Analytics (preview)" is an out-of-the-box tool that has proven very useful with very little effort. So I do hope that it continues as well.

schrapj
Автор

At first glance, this seems like a nice solution, but I have a question regarding the Ubuntu VM I need to create in order to setup the monitoring.
It would have been nice if the monitoring agent could be made available in some other way, because if I (as a DBA) want to setup the SQL monitor, I now have to deal with managing and maintaining a Linux operation system for which I do not have sufficient knowledge/experience and for which my server management team is unwilling to provide any support. I would prefer to see a solution which could take away the hassle of managing the Ubuntu OS.

Or am I seeing this wrong and does the Ubuntu not requires any maintenance? (upgrades/patches, ...)

looking forward to some feedback

bertvanlaar
Автор

After the creation of ubuntu 18.04 vm what should i install on it?
azure montior agent? or we just need an empty ubuntu 18.04 vm?

stefanosmanos
Автор

Hi where can i get custom KQL Queries like the one you ran @ 13:54

Mr_Mas_Complexities
Автор

16 minutes of marketing talk and all the guy said about what is it and why we need it was "new way of collecting data".
What data?
SQL Performance data?
Why do I need it?
Show us the sample data that you are collecting.
Guys, hire Brent Ozar. He will explain everything in plain English.

hsepo