Profile

See database activity in real time

The Real-Time View offers insight what database activity your application is performing, in real time. It offers a Chronological Connection View, which shows connections with commands / transactions in the order they're executed in real time, as well as a set of activity graphs which show the (aggregated) real-time data in graph form
Read more

Record activity into a snapshot

You can easily record activity in the ORM Profiler client with a single click into a snapshot, which can then be used for deep analysis. Creating a snapshot can also be done on the command line and even from within code.
Read more

The real time viewer's graph viewer

Analyze

Deep analysis system

Although SQL statements which take considerable time to execute are easy to spot, most problems with data-access code are revealed only through deeper analysis of the profiling data. ORM Profiler offers many configurable analysis features which are designed to spot these problems for you. Analysis is both done in real-time in the Real-Time View and in a snapshot.
Read more

Clever user-interface which offers multiple views on the same data

The user-interface consists of two parts, which are kept in sync when you switch between views. This way you can select a query in one view and switch to another view to see the same query in the context of that view, as each view will navigate to the query selected.

Obtain query execution plans directly from the database

ORM Profiler determines the exact time the execution of a SQL statement takes. If a query occurs to be slow, it might be the schema in the RDBMS needs further tweaking or the query itself might be using less efficient SQL. To see if that's the case, ORM profiler offers the ability to obtain the exact execution plan of a SQL statement from the RDBMS itself and shows this information in detailed form with the query. This way you can check for example whether a query uses indexes or performs a full table scan or whether the query performs excessive I/O.
Read more

Filtering system for narrowing down focus

A profiled application can generate a lot of profiling data, which might make focusing on a specific area of the application more difficult than expected. To overcome this, ORM Profiler offers a fine-grained filtering system which allows you to specify specific aspects of the area you want to focus on, ignoring the rest. This way you can quickly focus on a specific area of your application, avoiding distraction of areas you're not interested in.
Read more

Overview of three views on the same query

Fix

Navigate to method calls in Visual Studio or other editor

Execute, Open, Close and other major actions taken on ADO.NET objects are logged by ORM Profiler, including the stack trace of the originating call. ORM Profiler client views all these stack traces in full and, if applicable, lets you navigate directly to the file and line number of a method in a stack trace. If the file is open in a solution in a Visual Studio instance, it will navigate to the line in that file, otherwise it will open the file in a new instance of Visual Studio.

See queries in context of the executing code

One of the views on the profiling data offered by the ORM Profiler client application is Queries in Context, where each query is grouped below the stack trace of the method which executed the query. This way you not only see detailed query statistics but also which code executed the query and along which code path.

Additional information

It's free with every LLBLGen Pro subscription

You don't have to purchase ORM Profiler, it is free for every LLBLGen Pro subscription user. Simply download the installer from the 'My Account' menu after you've logged in and use your valid active LLBLGen Pro subscription license with the ORM Profiler client and you're set. You can also use an existing ORM Profiler v1.x license with ORM Profiler, so if your LLBLGen Pro subscription expires and you are an ORM Profiler v1.x licensee, you can keep using ORM Profiler using that v1.x license.

ORM Profiler v1.5 for ORM Profiler 1.x licensees

If you don't have an active LLBLGen Pro subscription and therefore no access to the ORM Profiler installer but do have a valid ORM Profiler v1.x license you can download the ORM Profiler v1.5 installer using the following link: ORM Profiler v1.5 installer.

What's supported

All databases using a DbProviderFactory are supported. All (Micro)ORM Frameworks using DbProviderFactory are supported on .NET 4.5.2 or higher or .NET Core 2.x+ / .NET 5+. For Entity Framework, only Entity Framework 6.x is supported.

Getting support

If you are an ORM Profiler v1.x licensee or have an active LLBLGen Pro subscription, you can get support for ORM Profiler using the LLBLGen Pro support forums. We've a dedicated public support forum for ORM Profiler and a private forum if your support request should only be visible by us and you.

Why wait?

Become more productive today.

Buy now    Download Trial