Geek Sync Webcast : Improving Query Performance in Azure SQL Database
Moving to Azure SQL can help with many things, including faster scalability and easier disaster recovery strategy implementation. Unfortunately, one thing it will not immediately do is fix bad code, which leads to bad performance even in Azure SQL.
In this hour-long session, we’ll examine several different methods that you can utilize to help fix bad performance starting with the underlying service tier. Next, we’ll investigate what options are available directly from the Azure portal to determine where the bottlenecks might reside along with possible ways to fix them. Lastly, we will interrogate which native SQL Server tools exist within Azure SQL Database that can really help solve any performance issues you might be having. You’ll leave this session with a solid understanding of how to troubleshoot performance issues in Azure SQL Database and what you might be able to do to help fix them.
Here is your download link for SQL Doctor!
Please choose the file that meets your system requirements:
You’ll also receive a confirmation email with a download link for your product. To ensure email delivery, please whitelist [email protected]. If you do not receive your email, please be sure to check both your inbox and filters for a message from [email protected]
John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. John led the Omaha SQL Server user group for 7 years and is now a leader of the Louisville SQL Server/Power BI user group. He is a Microsoft Data Platform MVP, 2016 IDERA ACE, blogger, avid tweeter, and a frequent speaker at SQL Saturday’s as well as other conferences. In his spare time, you can usually find John on Twitter (@sqlrus) as well as chasing his two young sons around the house.
24X7 SQL performance monitoring, alerting and diagnostics
- Monitor performance for physical, virtual, and cloud environments.
- Monitor queries and query plans to see the causes of blocks and deadlocks.
- Monitor application transactions with SQL Workload Analysis add-on.
- View expert recommendations from SQL Doctor to optimize performance.
- Alert predictively with settings to avoid false alerts.
- View summary of top issues and alerts with the web console add-on.