BT

InfoQ Homepage News ORM Profiler Analyzes Data Access Performance

ORM Profiler Analyzes Data Access Performance

Bookmarks

Solutions Design has released ORM Profiler, a tool meant to help improve data access layer performance. It tracks and logs ADO.NET calls so that developers can analyze their data access and discover potential problems.

ORM Profiler works with any data access layer built with the DbProviderFactory class using object-relational mapping (ORM), and any database that can be used via that data access layer, including SQL Server, MS Access, Oracle, MySql, SQLite, PostgreSQL, and DB2. It supports .NET Framework 3.5 and 4.0.

According to Solutions Design, only one line of code is required to activate ORM Profiler within an application, and it can be activated from their UI or from the command line. Rather than being a real-time profiler, it takes snapshots for later use. Database calls are logged and presented in three different views:

  1. in the context of the executing code, which allows the user to navigate to the relevant line in Visual Studio (or another code editor);
  2. in chronological order, grouped by transaction; and
  3. grouped by query.

Each of these views is kept in sync when an item is selected, so that the query can be analyzed in all three different ways. ORM Profiler also offers the ability to get the query execution plan from the database, and display it along with the query statistics.

Other features of ORM Profiler include:

  • support for multiple forms of data access at the same time, as long as they all use DbProviderFactory
  • the ability to profile multiple applications at once
  • a robust filtering system
  • profiling that can be switched on and off with one line of code
  • configurable alerts

More details on ORM Profiler can be found on its website.

Rate this Article

Adoption
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

BT

Is your profile up-to-date? Please take a moment to review and update.

Note: If updating/changing your email, a validation request will be sent

Company name:
Company role:
Company size:
Country/Zone:
State/Province/Region:
You will be sent an email to validate the new email address. This pop-up will close itself in a few moments.