Azure SQL VM Reimagined: Measuring Performance & Monitoring Health (Ep.3) | Data Exposed Live
723 بار بازدید -
3 سال پیش
-
In order to size a
In order to size a solution for the cloud it is important to consider the performance characteristics of your existing application, current pressures, the shape of your workloads, and your target for migration whether it be Azure SQL Database, Azure SQL Managed Instance, or Azure SQL Virtual Machine.
In this episode of Data Exposed Live with David Pless and Pam Lahoud, we will cover the performance metrics to collect as well as how to interpret these metrics into requirements for a new virtual machine in Azure. We will then dive into how to implement those requirements to continue to monitor your sizing for ongoing health.
Our goal is to simplify the monitoring and baselining capabilities using Windows perfmon, tooling, and capabilities in Azure to give you the tools to help maximize your Azure SQL investment. The areas we will focus on is performance monitor, perf diagnostics, Azure portal and dashboards, Azure Monitor & metrics, and capabilities offered in the latest Database Migration Assistant.
0:00 Show begins
0:26 Introductions
5:09 Azure SQL Virtual Machine Sizing Methodology
12:30 Storage Sizing for Data File Decision Tree
22:05 Storage Sizing for tempdb Decision Tree
32:35 Demo: Performance Monitor
35:41 Demo: PerfInsights Report
43:10 Azure Monitor
48:39 Demo: Azure Metrics, Uncached and Cached
57:58 Demo: Azure SQL VM Sizing Tool
59:06 Summary: Azure SQL VM Sizing Best Practices
✔️ Resources:
SQLDiag: https://docs.microsoft.com/en-us/sql/...
SQLNexus: https://github.com/Microsoft/SqlNexus...
Perfmon: https://docs.microsoft.com/en-us/wind...
PAL: https://github.com/clinthuffman/PAL?W...
Perfinsights: https://docs.microsoft.com/en-us/trou...
SQLinsights: https://docs.microsoft.com/en-us/azur...
📝 Azure SQL Virtual Machine Reimagined Series playlist: https://aka.ms/azuresqlvmyt
📌 Let's connect:
Twitter: David Pless, Twitter: dpless
Twitter: Pam Lahoud, Twitter: SQLGoddess
Twitter: Anna Hoffman, Twitter: AnalyticAnna
Twitter: AzureSQL, https://aka.ms/azuresqltw
🔴 To check out even more Data Exposed Live episodes, see our playlist: https://aka.ms/dataexposedlive
🔔 Subscribe to our channels for even more SQL tips: https://aka.ms/msazuresqlyt
✏️ If you are interested in finding out about Reactor sessions please check out our Reactor meetup page or sign up for our monthly newsletter:
https://aka.ms/MicrosoftReactorMeetup
https://aka.ms/ReactorEmailSignUp
#AzureSQL #AzureSQLVM #AzureSQLVirtualMachine
In this episode of Data Exposed Live with David Pless and Pam Lahoud, we will cover the performance metrics to collect as well as how to interpret these metrics into requirements for a new virtual machine in Azure. We will then dive into how to implement those requirements to continue to monitor your sizing for ongoing health.
Our goal is to simplify the monitoring and baselining capabilities using Windows perfmon, tooling, and capabilities in Azure to give you the tools to help maximize your Azure SQL investment. The areas we will focus on is performance monitor, perf diagnostics, Azure portal and dashboards, Azure Monitor & metrics, and capabilities offered in the latest Database Migration Assistant.
0:00 Show begins
0:26 Introductions
5:09 Azure SQL Virtual Machine Sizing Methodology
12:30 Storage Sizing for Data File Decision Tree
22:05 Storage Sizing for tempdb Decision Tree
32:35 Demo: Performance Monitor
35:41 Demo: PerfInsights Report
43:10 Azure Monitor
48:39 Demo: Azure Metrics, Uncached and Cached
57:58 Demo: Azure SQL VM Sizing Tool
59:06 Summary: Azure SQL VM Sizing Best Practices
✔️ Resources:
SQLDiag: https://docs.microsoft.com/en-us/sql/...
SQLNexus: https://github.com/Microsoft/SqlNexus...
Perfmon: https://docs.microsoft.com/en-us/wind...
PAL: https://github.com/clinthuffman/PAL?W...
Perfinsights: https://docs.microsoft.com/en-us/trou...
SQLinsights: https://docs.microsoft.com/en-us/azur...
📝 Azure SQL Virtual Machine Reimagined Series playlist: https://aka.ms/azuresqlvmyt
📌 Let's connect:
Twitter: David Pless, Twitter: dpless
Twitter: Pam Lahoud, Twitter: SQLGoddess
Twitter: Anna Hoffman, Twitter: AnalyticAnna
Twitter: AzureSQL, https://aka.ms/azuresqltw
🔴 To check out even more Data Exposed Live episodes, see our playlist: https://aka.ms/dataexposedlive
🔔 Subscribe to our channels for even more SQL tips: https://aka.ms/msazuresqlyt
✏️ If you are interested in finding out about Reactor sessions please check out our Reactor meetup page or sign up for our monthly newsletter:
https://aka.ms/MicrosoftReactorMeetup
https://aka.ms/ReactorEmailSignUp
#AzureSQL #AzureSQLVM #AzureSQLVirtualMachine
3 سال پیش
در تاریخ 1400/04/23 منتشر شده
است.
723
بـار بازدید شده