Huagati Query Profiler
Huagati Query Profiler is a toolkit that enable runtime profiling of Linq-to-SQL, Entity Framework v4, and LLBLGen Pro 2.6 based software accessing Microsoft SQL Server databases. It consists of the Huagati Linq-to-SQL Profiler, Huagati EF Profiler, and Huagati LLBLGen Profiler runtime components, and a profiler log explorer application.
The runtime components are designed to be integrated and distributed with applications
that are using either Linq-to-SQL, Entity Framework v4, or LLBLGen Pro for accessing SQL Server. This enables you to build in powerful query logging and profiling functionality in your applications, allowing database performance troubleshooting to be turned on and off during development, test, and in live production environments. Runtime filters allow application developers to target specific SQL query behavior such as excessive reads, excessive execution times, table scans, queries with no matching indexes, and many other scenarios that can have an impact on database and application performance.
Use the profiler to proactively detect potential performance bottlenecks, and to gain an understanding of how your applications interact with the underlying database(s).
Don't forget to also check out Huagati DBML/EDMX Tools
- the add-in that completes the Linq-to-SQL and EF designers in Visual Studio 2008 and Visual Studio 2010 with missing functionality such as mass-renaming, model ⇔ database synchronization, update code documentation from database extended properties, etc. Click here for more information!