Huagati DBML/EDMX Tools     Huagati Query Profiler     About     Contact
Huagati Query Profiler

Huagati Query Profiler is a toolkit that enable runtime profiling of Linq-to-SQL, and LLBLGen Pro based software accessing Microsoft SQL Server databases. It consists of the Huagati Linq-to-SQL 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, or LLBLGen Pro for accessing SQL Server. The runtime components add functionality to log and profile database query cost and performance throughout the lifespan of an application; 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).

Download Click here to download! Current version: 1.30 released on 3 June 2010

After downloading, click here to retrieve a free 20-day trial license key, or click on the "Download/Licensing" tab below to see all licensing options.

 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 with missing functionality such as mass-renaming, database synchronization, update code documentation from the database 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 both Linq-to-SQL based 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 three components;
  1. 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.
  2. 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.
  3. 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
The profiler log viewer application's main window (click for larger image)


Copyright © 2005-2010, Huagati Systems Co., Ltd.