SQL Server Execution Plan Operators
Vložit
- čas přidán 21. 07. 2024
- In this episode we take a look at the most common execution plan operators that may indicate serious performance problems in your SQL queries. Check out the rest of my series on SQL Server execution plans here: • How To Read SQL Server...
Subscribe and turn on notifications to never miss a weekly video: czcams.com/users/DataWithBer...
Check out the blog post for more examples and links:
bertwagner.com/2019/08/13/sql...
Episode on rewriting window spools:
• Window Functions vs Gr...
SQL Server Join Operator Internals:
• The Importance of Nest...
• Merge Join Internals i...
• Hash Match Join Intern...
Follow me on Twitter:
/ bertwagner - Věda a technologie
Thank you for reminding me to take a closer look at the execution plan metrics more often!
Bert, you are a really knowledgeable on this topic and very good on presenting it. Thank you very much.
Great video Bert, very informative.
Short,Clear and very useful.Amazing thank you so much.just subsribed today
WOW! Great video Bert. I'll have to watch it again as well as the others you've referenced. As for parallelism, you mentioned Cost Threshold for Parallelism indicating that you do not leave it at its default value. What about MAXDOP? Do you typically change MAXDOP or do you usually leave it at its default. Currently our servers still hold the default values for both of those properties which I think we should change; I'm just a little bit leery of doing so fearing that it may cause other issues. I'm under the impression that there's less risk in changing the Cost Threshold than there is with changing MAXDOP. Is that a fair statement?
Thanks again for all these great videos! I really appreciate them.
Amazing videos. Great job sharing knowledge.
content that is worth its time :)
credits for such valuable materials :)
thx!!!
btw why You have the Polish emblem (white eagle on red shield) on your laptop? :)
These videos are great! Thanks!
Greath video thanks a lot Berth keep with the good work!,
Very informative video. Thanks a ton!
Hi thanks again for great video .
Would you mind to show some examples for deciding value of cost threshold p. and Maxdop ??
Bcz I am currently dealing with more than 100 server and it’s hard to find some best values as each one has different load.
Also found higher CZPACKET wait under top 5 wait list ...
Covering indexes are the good choice for any key lookup plan .. but always face one issue as one of my table is having almost 184 columns and end users can pick any column in their queries. So end up build many indexes which is very bad practice.
So what’s your view on this sir ?? SQL version is 2008 & 2012 .
Waiting for next video ... keep up the good work n thanks.
Thank you Bert 👍🏼
Great video.
I've noticed coat of arms of Poland on your computer. Do you have any relationship with Poland? Cheers from Poland!
It would be nice to show database table and actual data. Your videos are really good. But missing something.
When to use estimated execution plan and actual execution plan?
Thanks Bert
HI, I have a question, can you please help.
I have a query which is used when some form opens, it takes about a minute for user to wait.
I know that system is not using most efficient plan.
is there any way to force Query Optimiser spend about 1-2 hours to analise all possible way of retriving data so the next time it will use the most efficient plan
my man thanks
Good video but let me rent a little.
Shit guys, I do not know what is the reason to use SQL Server, everything is OVERCOMPLICATED. Even simple things like creating auto increment field, add index or show DDL how table was created with all indexes/keys ..., almost impossible to do or it takes forever to do. it's a pain in ass.
Microsoft "Query analyzer" ... Oh my goodness, it is barely understandable, it shows all kind of information except information I needs !!!! In MySQL it's much better and simpler!!!
Don't show theory..give some practical
Bro this one is not with the other four in the ex plan playlist 😢
Thanks for letting me know, I added it.
@@DataWithBertBert: you are my absolute favourite SQL/DB/MSSQL youtuber, bar none. I’ve probably learned more from you about SQL than I have from the countless SO threads, tutorial channels, articles (shoutout to SQLShack, which has pretty consistently good content).
But, next to you, it is no contest. Thank-you for sharing your voodoo wizardry!