Pour bénéficier d’une expérience Web optimale, utilisez Internet Explorer 11 ou version ultérieure, Chrome, Firefox, ou Safari.

Database Training Days: 201 | Query Store on Prem and Cloud: The Simplest Way to Troubleshoot Performance

Database Training Days
a la demande
  • Date enregistrée:Jul. 8, 2024
  • Événement:a la demande
Database Training Days

I live and breathe in Query Store everyday as a Performance Tuning consultant. I am able to quickly find performance issues without knowing my clients code or applications to help them fix or discover on going performance issues. The Query Store feature provides you with insight on query plan choice and performance. It gives you more control over which execution plans the optimizer will utilize and insights into plan regressions. In this session, we'll discuss what the Query Store is, how it works, how you should configure it for your environment, and how to get even more information by using the underlying DMVs that support it. We'll learn how to quickly find performance differences caused by query plan changes, identify quick performance anomalies, and solve performance issues in minutes using a combination of discussion and demos. We'll cover how you can use the Query Store to answer the question “Why was my query slow?"

Speaker
Monica Rathbun
Microsoft MVP for Data Platform, Microsoft Certified Solutions Expert and VMWare vExpert
Monica Rathbun lives in Virginia, is a Microsoft MVP for Data Platform, Microsoft Certified Solutions Expert and VMWare vExpert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group, on the Microsoft Azure Data Community Board and the Data Saturdays Board. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. 
Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. 
You can find Monica blogging at sqlespresso.com

Regarder votre webcast gratuit

Veuillez patienter...

triangle-down check
En téléchargeant, vous vous inscrivez pour recevoir des e-mails marketing de notre part. Pour vous désinscrire, veuillez suivre les instructions figurant dans notre politique de confidentialité.

Site protégé par reCAPTCHA. Consultez les conditions d’utilisation et la politique de confidentialité de Google.