SQL Profiling in Optimizely CMS 12 - Optimizely from Scratch

A relatively quick introduction to some simple tools to get you started in performance profiling in Optimizely CMS (or other ASP.NET applications). Netling: https://github.com/hallatore/Netling Errata: I mention that things in IContentLoader are cached, which is definitely an oversimplification. One can have custom content providers, which can affect caching. Context can affect caching (caching rules are different for code running in a Scheduled Job for example). It's a complex subject and when I say, "things should be cached," what I really mean that in most instances, out of the box, they probably will be. Caching is hard. Your mileage may vary. Source code can be found here: https://github.com/mrdrbob/cms12-from... - check out the tag `episode/06-sql-profiler` to be at the same state as the start of this video. Chapters: 00:00:00 Introduction 00:02:20 Local Load Test with Netling 00:05:53 SQL Server Profiler 00:11:11 Finding the SQL call source in code 00:17:37 Outro and tease This is part of the Optimizely CMS 12 from Scratch series: 01 - Project Setup -    • Optimizely CMS 12 Project Setup - Optimize...   02 - Content Modeling -    • Content Modeling in Optimizely CMS 12 - Op...   03 - Rendering Content -    • Rendering Content in Optimizely CMS 12 - O...   04 - Working with Content -    • Working with Content in Optimizely CMS 12 ...   05 - Events and Scheduled Jobs -    • Events and Scheduled Jobs in Optimizely CM...   06 - SQL Profiling -    • SQL Profiling in Optimizely CMS 12 - Optim...