How to Troubleshoot a Slow Running Query in SQL Server by Amit Bansal (Recorded Webinar)
Vložit
- čas přidán 26. 07. 2024
- Explore SQLMaestros All-In-One Performance Tuning Bundle. 5 courses at a highly discounted price. bit.ly/sqlmaestrosallinone
Learn about the largest online learning event on Azure Data, Analytics & AI covering 30+ technologies including SQL Server, Power BI, MS AI stack, Azure Data stack & Advanced Analytics stack: www.DataPlatformVirtualSummit...
Follow us on Twitter
/ thedatageeks
/ sqlservergeeks
/ dataaisummit
/ sqlmaestros
/ a_bansal
.
.
Webinar Description
You always wanted to troubleshoot a slow running query. But you just don’t know where to begin. In this demo-heavy session, I will show you how to troubleshoot a slow running query. You will see an end-to-end query tuning example with a slow running workload. We will capture important metrics while the workload is running and then use the captured data to troubleshoot query performance issues. The technique you will learn can be applied to production straight away. This will be a 100% demo session.
Webinar resources including presentation, demo files, code snippets and more learning material is available on www.dataplatformgeeks.com/ (Join for free and access all the resources)
Important Links:
DataPlatformGeeks: www.dataplatformgeeks.com/
SQLServerGeeks: www.SQLServerGeeks.com
Browse free learning material from our knowledge partner: www.SQLMaestros.com - Věda a technologie
I liked the way you explained it. Learned a lot of new stuff. Thanks!
Very well demonstrated..
love your videos!
Loved it
In 57 minutes you just talked on wait stats, expecting more troubleshoot techniques as mentioned in the subject.
Wasted 57 mins to Just see execution plan and wait type...we are actually looking for how do you troubleshoot these issues