Episode

High CPU due to anti-pattern queries [3 of 7] | Azure SQL for beginners

with Bob Ward

Azure SQL for Beginners

In this episode we will look at another scenario involving high CPU causing a performance problem. This scenario involves the use of T-SQL queries called anti-pattern queries. An anti-pattern query is a query that is used often but is written or designed in a way that results in poor performance. We will look at examples of these types of queries, the signature of a performance problem that can occur, and solutions to resolve the problem.

Chapters

  • 00:00 - Introduction
  • 00:53 - What is an anti-pattern query?
  • 02:00 - The troubleshooting process
  • 02:40 - Demo
  • 07:33 - Anti-pattern query examples
  • 08:06 - Summary
  • 08:30 - Learn more

Azure
Azure SQL Database

Have feedback? Submit an issue here.