Huagati Query Profiler - Huagati Systems Co., Ltd.

Huagati DBML/EDMX Tools

Huagati Query Profiler

About

Contact

Blog

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!

OverviewRuntime ComponentLog ViewerDownload / LicensingHelp and Support

Overview

Runtime performance aspects of database driven applications is often complex, cumbersome, and time-consuming to investigate. Dependant on a multitude of factors such as system configuration, SQL Server configuration, data volumes, indexing and index statistics, an application may behave different between development, test, and production environments.

Having the right tools to runtime profile a production application and how it interacts with the underlying SQL Server database is essential for pinpointing bottlenecks, identifying required configuration, index, and code changes.

Huagati Query Profiler is a toolkit that adds profiling capabilities with advanced tracking options to Linq-to-SQL, Entity Framework v4, and LLBLGen Pro based software. It helps you see not only what SQL queries are sent to to the database, but also how those queries affect the database and where in your application they originated.

Huagati Query Profiler consists of four components;

a royalty-free redistributable runtime extension library that adds query profiling functionality to Linq-to-SQL datacontexts. Basic profiling requires only two added method calls to existing code; BeginProfiling and EndProfiling, while more advanced options with pre-defined filters and custom filters are available for more complex profiling tasks.
a royalty-free redistributable runtime extension library that adds query profiling functionality to Entity Framework v4 object contexts. Basic profiling requires only minor adjustments to existing code, while more advanced options with pre-defined filters and custom filters are available for more complex profiling tasks.
a royalty-free redistributable runtime extension library that adds query profiling functionality to LLBLGen Pro 2.6 Data Adapters. An included partial class makes it easy to integrate and get started with profiler logging in existing LLBLGen Pro based applications. Advanced filter options such as pre-defined filters and custom filters are available for more complex profiling tasks.
a non-redistributable profiler log viewer/log explorer enabling developers, DBAs, product/program managers, and system administrators to browse the profiler logs, identify expensive queries, view the managed call stack that generated the query, see vital SQL Server I/O and timing statistics from the actual execution of the query.

The profiler log viewer application's main window (click for larger image)

Additional information for the profiling capabilities for each OR mapper is available here:

Linq-to-SQL: Profiling Linq-to-SQL applications
Entity Framework v4: Entity Framework support in Huagati Query Profiler
LLBLGen Pro v2.6: Query Profiling for LLBLGen Pro-based applications

Download / Get a license

Click here to download! Current version: 1.34 released on 14 December 2010

Click here to retrieve a free trial license key.

To install, unzip the download package and run setup.exe.

Licensing Options
Free Trial The log viewer is limited to displaying 500 log entries at a time. The trial license is valid for 30 days from installation. Click here to retrieve a license key for the free trial edition!	Standard The log viewer is limited to displaying 800 log entries at a time. No expiry. Single user license $19.95 USD	Professional No limits imposed. The log viewer will display as many log entries as system memory allows it to load. Single user license $39.95 USD

Note: Each license for Huagati DBML/EDMX Tools Professional Edition purchased during 2010 or later also includes a free bundled license for Huagati Query Profiler Professional Edition.

For buyers in Thailand, 7% VAT will be added to the price during PayPal checkout.

Please contact us if you need an invoice, tax invoice or want to pay via bank wire transfer (available for orders within Thailand, or for international orders over USD $500).