Skip to content

Instantly share code, notes, and snippets.

@airtank20

airtank20/Optimizing Query Performance in Azure SQL Database

Created March 5, 2020 22:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save airtank20/472a943922ab755a083771e7a4b97392 to your computer and use it in GitHub Desktop.
Save airtank20/472a943922ab755a083771e7a4b97392 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Optimizing Query Performance in Azure SQL Database
Many think that moving to the cloud will not only help brighten your teeth but also solve all your bad coding practices that give you poorly performing queries. If it's done correctly, implementing Azure SQL Database can help with one of those two and while it can mask things well, the best solution is to fix the bad code. In this hour-long session, we'll examine several different methods that you can utilize to help fix bad query 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 performance issues you might be having. You'll leave this session with a solid understanding of how to trouble shoot performance issues in Azure SQL Database and what you might be able to do to help fix them.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment