tubeshowcase●1,670,700 videos♡ My collection 0
← Learn to Code

Learn to Code09:12

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

Microsoft Developer ↗

From the creator

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. 0:00 Introduction 0:53 What is an anti-pattern query? 2:00 The troubleshooting process 2:40 Demo 7:33 Anti-pattern query examples 8:06 Summary 8:30 Learn more Resources: For the full Azure SQL for beginners Special Edition series on Performance Troubleshooting, watch: https://aka.ms/performanceseries For the full Azure SQL for beginners series, watch: https://aka.ms/azuresql4beginners Learn more about anti-pattern queries: https://aka.ms/sqlantipattern Azure SQL Workshop​: https://aka.ms/azuresqlworkshop Azure SQL Fundamentals​: https://aka.ms/azuresqlfundamentals Watch Data Exposed​: https://aka.ms/dataexposed See more videos from our team​: https://aka.ms/azuresqlyt Follow us on social media​: https://aka.ms/azuresqltwitter Read the books: https://aka.ms/azuresqlbook, https://aka.ms/azuresqlfordevelopers

Published 2023-02-08 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.

Keep exploring Learn to Code