via @dotnet : EFCore.Visualizer – View Entity Framework Core query plan inside Visual Studio
https://ift.tt/cOdnCTJ
#EFCore #EntityFrameworkCore #VisualStudio #QueryPlan #LINQ #ORM #DatabasePerformance #SoftwareDevelopment #DeveloperTools #Coding #Programming #O…
How often is the query plan optimal?
https://vondra.me/posts/how-often-is-the-query-plan-optimal/
#HackerNews #How #often #is #the #query #plan #optimal? #queryplan #database #optimization #performance #analysis #HackerNews
Yo, #sqlserver tuners and optimizers, I have a question: under what circumstances would a #queryplan prefer a scan of a clustered index rather than a seek of a non-clustered index with the same predicate and output fields?
I've been pouring over query plans lately, trying to reduce pressure of processes in an environment that sees thousands of processes running, with hundreds at the same time, contending for data access, CPU time, and file locks.
Currently works for sql server but other flavours of sql should work for the text and xml diff options. Try it at
https://querydiff.com/
Feedback needed!
#sql #database #querydiff #queryplan
4/4
There is also a table under the “statistics” tab where you can sort by cpu, row count etc
You just upload or copy paste your query plan as xml and go to the visual tab. Voila! Hover or click nodes to see details
#sql #database #querydiff #queryplan
2/4
I got a bit frustrated trying to compare query plans in sql server management studio so I made a website to do side by side comparisons.
https://querydiff.com
#sql #database #querydiff #queryplan
1/4
Blog alert!
The sequel to the mystery of why the query didn't go parallel
Where the heroes of the #sqlfamily shine.
Thank you Daniel, Cláudio, Fredrik and Bouke for your input!
#sqlserver #microsoft #dba #queryplan #tuning
http://sqlreitse.com/2023/11/11/why-wont-you-go-parallel-part-2/
