Azure SQL Database Query Optimization using Query Store to Reduce Costs by Torsten Strauss

preview_player
Показать описание
Learn about how to analyze and optimize queries with techniques that can be used to reduce your Azure SQL Database costs by optimizing your query workloads. Techniques are covered with a SQL Server context; however, those techniques can also be used to optimize your Azure SQL DB environments.

- Topics Covered:
. Azure SQL Database Query Tuning
. Query Store
. Azure SQL Database Resource Analysis
. Azure SQL Database Workload

The Microsoft Data and AI South Florida user group along with Torsten Strauss and supporters host another great event in its Worldwide Presentation Series.

- Title:
Reduce Azure SQL costs by optimizing your query workload by Torsten Strauss

- Abstract:
Query tuning of an Azure SQL environment is a way to reduce costs by scaling down resources. The less resources your workload requires, the less money you have to pay - therefore it is important to analyze and optimize the queries on a regular basis. Microsoft supports us with various features, including the Query Store introduced in SQL Server 2016. In this session, you will learn how to use the Query Store to analyze and optimize the SQL Server workload and avoid plan regressions through Automatic plan correction.

- Bio: ​​
Torsten (MVP, MCSE, MCT) has been working with Microsoft SQL Server since the turn of the millennium and is specialized in performance optimization for large SQL Server environments. He has been with BP as a database engineer for over two decades and collaborates closely with Sarpedon Quality Lab as a Principal Microsoft SQL Server Consultant.

Connect with our supporters who make it all possible
____________________________________
* Torsten Strauss:

____________________________________

** Join DataAISF - Microsoft Data and AI South Florida User Group**

____________________________________
- DATE & TIME:
Date : Wed. May 5th 2021
Time : 5:00 pm US EST

- LOCATION:
* Online:
Subscribe to the channel & Click on the Bell

RSVP and Bring a Friend:

- Join DataAISF - Microsoft Data and AI South Florida User Group

Рекомендации по теме