How to tune data access layers .net

on YouTube ↗46m

" summary

Shows advanced .NET data-access tuning techniques: using interceptors and a modified Entity Framework, profiling with ANTS and SQL Server Profiler, and analyzing captured DAL data with PowerPivot to find and fix performance issues.

AI-written summary · about

" chapters (14)

1. 0:00Introduction
2. 2:30Tuning approaches in .NET
3. 7:22Demo with Entity Framework
4. 12:01Uncached query problem
5. 15:29Parametrized vs inline queries demo
6. 20:47Stored procedure solution
7. 22:56Entity Framework interceptors
8. 27:12First queries and compilation time
9. 28:40Measuring EF times
10. 31:09EF query compilation
11. 37:33CPU impact of compilations
12. 39:19Redgate data processing
13. 41:07Dictionaries vs lists
14. 45:21Summary

" related talks

• 01h 02mUnlocking the Full Potential: The Harmonious Dance of EF Core and SQL ServerJernej Kavka · NDC Sydney 2024
• 56mEntity Framework debugging using SQL Server: A Detective StoryChris Woody Woodruff · NDC Oslo 2019
• 59mLessons Learned from the Trenches: Connectivity and Performance Tips&TricksJose Manuel Jurado Diaz · NDC London 2021
• 51mPerformance Tuning Azure SQL DatabaseMonica Rathbun · SQLBits 2023
• 01h 00mGetting the best out of Entity Framework CoreJon P Smith · NDC London 2020
• 01h 01mEntity Framework Core Unchained Getting the Best Performance from Your ORMDan Mallott · NDC Melbourne 2022
• 45m.NET: SQL vs ORM - Will Dapper Resolve the Age-Old Debate?Kamil Wysocki · 4Developers 2020
• 01h 04mCommon mistakes in EF CoreJernej Kavka · NDC Porto 2023