December 2021 - Intro to Query Store by Deepthi Goguri (@dbanuggets)
Abstract:
Are you facing performance issues due to parameter-sensitive queries? Are many plans being generated for your queries and you cannot control choosing the plan best for your query? Come learn in this session how we can capture the different plans generated for those queries and decide which plan you can force for better performance using the Query Store feature. Query Store feature introduced in SQL Server 2016 and has advanced its features introducing Wait stats per Query plan and Automatic Plan correction feature in SQL Server 2017 and Azure SQL database which will force the plans and resolve the issues automatically for you. Sound’s amazing, right? Join Deepthi to know all about the Query Store feature and its advancements in detail so you can implement them to take advantage of this awesome feature!
About Speaker
Deepthi is a SQL Server Database Administrator with several years of experience in Administering SQL Servers. She is a Microsoft certified trainer and Microsoft certified professional with an Associate and Expert level Certification in Data Management and Analytics. Deepthi blogs for DBANuggets.com. Deepthi is a Co-Organizer for Microsoft Data and AI South Florida user group and Data Platform Diversity, Equity, and Inclusion Virtual Group. She is a Volunteer for Data platform Women in Technology user group. She is a Friend of Redgate. Along with this, Deepthi loves arts and crafts. You can contact her on Twitter @dbanuggets.
-
3:53:56
Alex Zedra
8 hours agoLIVE! STILL Giving away an M249 SAW | Gaming tonight!
26.9K9 -
19:41
Squaring The Circle w/ Randall Carlson
10 hours ago#001 An Introduction To Squaring The Circle - Squaring The Circle: A Randall Carlson Podcast
32.1K30 -
12:03
ThinkStory
18 hours ago64 MAJOR Differences Between SHOGUN (1980) and SHOGUN (2024)
39.3K23 -
26:37
TheTapeLibrary
21 hours agoAnatoly Moskvin | Horrifying Crimes of The Russian Puppeteer
49.9K30 -
6:16
Film Threat
14 hours agoDEADPOOL & WOLVERINE TRAILER REACTION | Film Threat Reviews
32.5K14 -
29:36
Science & Futurism with Isaac Arthur
20 hours agoClearing Space Debris
38.7K16 -
6:55
Chrissy Clark
10 hours agoLGBT Activists Want Katy Perry To Stop THIS?!
38K25 -
16:27
justintech
14 hours agoBest Gaming PC 2024 For Every Budget!
38.7K2 -
1:22:40
Crime Circus
15 hours agoBad Boy sneaks KNIFE into interrogation!!
44.1K7 -
2:06:10
Laura Loomer
9 hours agoEP44: TRUMP ON TRIAL: SCOTUS Hears Presidential Immunity Arguments Ahead of 2024 Election
48.9K46