Benchmarking SQL Server and Azure SQL with WorkloadTools | Data Exposed: MVP Edition
Lifting and shifting your application to the cloud is extremely easy, on paper. The hard truth is that the only way to know for sure how it is going to perform is to test it. Benchmarking on-premises is hard enough, but benchmarking in the cloud can get really tricky due to changes in what's exposed in PaaS environments. WorkloadTools is a set of open-source tools that can help you capture, analyze, and replay your workload, on-premises, and in the cloud. In this episode of Data Exposed: MVP Edition, Gianluca Sartori introduces the tool and its capabilities.
[01:13] What is a benchmark?
[03:26] Benchmarking process
[05:20] Open source tools for benchmarking
[06:05] Analyzing a workload
[07:17] Reporting tool example showing an analysis database
[08:08] Saving workload
[08:46] Replaying a workload
[10:45] Configure a SQL workload
[12:40] Sizing a workload
✔️ Additional Resources:
WorkloadTools on GitHub:
https://github.com/spaghettidba/WorkloadTools?WT.mc_id=dataexposed-c9-niner
https://github.com/spaghettidba/WorkloadTools/releases?WT.mc_id=dataexposed-c9-niner
https://github.com/spaghettidba/WorkloadTools/wiki?WT.mc_id=dataexposed-c9-niner
https://github.com/spaghettidba/WorkloadTools/issues?WT.mc_id=dataexposed-c9-niner
WorkloadTools blog: https://spaghettidba.com/tag/workloadtools?WT.mc_id=dataexposed-c9-niner
Capturing extended events to Azure blob storage: https://blobeater.blog/2018/05/08/extended-events-using-azure-storage?WT.mc_id=dataexposed-c9-niner
About Gianluca Sartori:
Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and in Italy in particular. He is currently working as lead DBA at a famous Formula 1 team.
About MVPs:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real-world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram
🔴 To watch even more Data Exposed episodes, check our playlist: https://aka.ms/dataexposedyt
📌 Let's connect:
Twitter - Gianluca Sartori, https://twitter.com/spaghettidba
Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna
Twitter - AzureSQL, https://aka.ms/azuresqltw
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt
#MVPTuesday #WorkloadTools #AzureSQL #MVPBuzz #DataPlatformMVP
Видео Benchmarking SQL Server and Azure SQL with WorkloadTools | Data Exposed: MVP Edition канала Microsoft Developer
[01:13] What is a benchmark?
[03:26] Benchmarking process
[05:20] Open source tools for benchmarking
[06:05] Analyzing a workload
[07:17] Reporting tool example showing an analysis database
[08:08] Saving workload
[08:46] Replaying a workload
[10:45] Configure a SQL workload
[12:40] Sizing a workload
✔️ Additional Resources:
WorkloadTools on GitHub:
https://github.com/spaghettidba/WorkloadTools?WT.mc_id=dataexposed-c9-niner
https://github.com/spaghettidba/WorkloadTools/releases?WT.mc_id=dataexposed-c9-niner
https://github.com/spaghettidba/WorkloadTools/wiki?WT.mc_id=dataexposed-c9-niner
https://github.com/spaghettidba/WorkloadTools/issues?WT.mc_id=dataexposed-c9-niner
WorkloadTools blog: https://spaghettidba.com/tag/workloadtools?WT.mc_id=dataexposed-c9-niner
Capturing extended events to Azure blob storage: https://blobeater.blog/2018/05/08/extended-events-using-azure-storage?WT.mc_id=dataexposed-c9-niner
About Gianluca Sartori:
Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and in Italy in particular. He is currently working as lead DBA at a famous Formula 1 team.
About MVPs:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real-world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram
🔴 To watch even more Data Exposed episodes, check our playlist: https://aka.ms/dataexposedyt
📌 Let's connect:
Twitter - Gianluca Sartori, https://twitter.com/spaghettidba
Twitter - Anna Hoffman, https://twitter.com/AnalyticAnna
Twitter - AzureSQL, https://aka.ms/azuresqltw
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt
#MVPTuesday #WorkloadTools #AzureSQL #MVPBuzz #DataPlatformMVP
Видео Benchmarking SQL Server and Azure SQL with WorkloadTools | Data Exposed: MVP Edition канала Microsoft Developer
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![](https://i.ytimg.com/vi/_YqsFg2_j-k/default.jpg)
![Deploying SQL Server 2019 in Kubernetes | Data Exposed: MVP Edition](https://i.ytimg.com/vi/bukTY7LUvr8/default.jpg)
![How to migrate SQL Server databases to Azure](https://i.ytimg.com/vi/P_4EaqVR5PI/default.jpg)
![Azure SQL Capacity Planning: DTU or vCore? | Data Exposed](https://i.ytimg.com/vi/1AKDj0_wOFs/default.jpg)
![Inside a Google data center](https://i.ytimg.com/vi/XZmGGAbHqa0/default.jpg)
![Private Link for Azure SQL Database - Part 1 | Data Exposed](https://i.ytimg.com/vi/yqfvTXkniy0/default.jpg)
![What is SQL? [in 4 minutes for beginners]](https://i.ytimg.com/vi/27axs9dO7AE/default.jpg)
![Azure SQL – Automated Backups (Part 2) | Data Exposed](https://i.ytimg.com/vi/Vk2LEMtCbmU/default.jpg)
![How to migrate your MySQL database to the cloud | Azure Tips and Tricks](https://i.ytimg.com/vi/uxSDpZnFa18/default.jpg)
![Auto-failover groups in Azure SQL | Data Exposed](https://i.ytimg.com/vi/eH91n3EtV7c/default.jpg)
![The Benefits of Advanced Threat Protection in Azure SQL Database | Data Exposed: MVP Edition](https://i.ytimg.com/vi/6JbSinh2FHQ/default.jpg)
![Move Oracle to Azure SQL Server in Real Time](https://i.ytimg.com/vi/enB0EQwC9m8/default.jpg)
![How to Shut Off Public Connectivity to Azure SQL Database | Data Exposed](https://i.ytimg.com/vi/9JVNX2JCmDQ/default.jpg)
![What is the difference between Database vs. Data lake vs. Warehouse?](https://i.ytimg.com/vi/E49BFhThC3U/default.jpg)
![Microsoft SQL Server Licensing Models](https://i.ytimg.com/vi/1gJ8VGwdoyk/default.jpg)
![Azure SQL Capacity Planning: Overview | Data Exposed](https://i.ytimg.com/vi/BbcVl9ZKtf8/default.jpg)
![Azure SQL Database: Improving Performance Tuning with Automatic Tuning | Data Exposed: MVP Edition](https://i.ytimg.com/vi/HQantpWg3sg/default.jpg)
![SQL vs NoSQL or MySQL vs MongoDB](https://i.ytimg.com/vi/ZS_kXvOeQ5Y/default.jpg)
![Improve SQL Server performance using profiler and tuning advisor](https://i.ytimg.com/vi/AaPaIVI-yyI/default.jpg)
![System administration complete course from beginner to advanced | IT administrator full course](https://i.ytimg.com/vi/1DvTwuByjo0/default.jpg)