SQL Server Profiler is a tool every developer should have in their repertoire. With the use of frameworks and abstractions, we often lose sight of what is actually hitting the database, and there’s no better way to get that information than SQL Server
Profiler. It has a few knobs and dials that we’ll cover here, and we’ll look at a sample scenario to ‘debug’ a faulty Entity Framework expression.