Express Profiler – free tool for SQL Server profiling
If we write code working with databases, usually it is beneficial to preview what SQL is used during the system use. It is the most useful when we want to use some ORM like Entity Framework. Each query executed by Entity Framework is transformed into some SQL query, the it is executed on database. Profilers is mostly use to:
– complexity check of generated SQL query
– query optimization
– checking of existence of common querying problems (e.g N+1 problem)