BT

Your opinion matters! Please fill in the InfoQ Survey!

ORM Profiler Analyzes Data Access Performance

| by Jenni Konrad  Followers on Oct 14, 2011. Estimated reading time: 1 minute |

A note to our readers: As per your request we have developed a set of features that allow you to reduce the noise, while not losing sight of anything that is important. Get email and web notifications by choosing the topics you are interested in.

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 Stage
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.

Tell us what you think

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

Email me replies to any of my messages in this thread
Community comments

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

Email me replies to any of my messages in this thread

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

Email me replies to any of my messages in this thread

Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT