OpenAccess and MiniProfiler

[Peter]

I tried to enable OpenAccess for usage with MiniProfiler (http://miniprofiler.com/).

MiniProfiler provides a "ProfiledDbProviderFactory" which wraps the calls to the underlying DbProviderFactory. To enable the DbProviderFactory I added the following lines to web.config (like in this article: http://www.telerik.com/help/openaccess-orm/openaccess-tasks-deployment-resolving-ado-net-driver.html):

<system.data>
    <DbProviderFactories>
      <remove invariant="StackExchange.Profiling.Data.ProfiledDbProvider" />
      <remove invariant="System.Data.SqlClient" />
      <add
        name="StackExchange.Profiling.Data.ProfiledDbProvider"
        invariant="System.Data.SqlClient"
        description="StackExchange.Profiling.Data.ProfiledDbProvider"
        type="StackExchange.Profiling.Data.ProfiledDbProviderFactory, StackExchange.Profiling, Version=1.9.0.0, Culture=neutral, PublicKeyToken=b44f9351044011a3" />
    </DbProviderFactories>
  </system.data>

On debugging I see the correct DbProviderFactory set in myDomainService.DataContext.database.BackendConfiguration.BackendInfo.ProviderFactory

But no calls to the database are profiled by MiniProfiler.

Any tipps on how to integrate MiniProfiler into OpenAccess?

[Damyan Bogoev]

Hello Peter,

I am afraid that OpenAccess ORM cannot be used with MiniProfiler, it cannot run with wrapped ADO provider.

Actually you could use the OpenAccess Profiler and Tuning Advisor in order to profile the performance of your application. It will provide you with similar information.

Hope that helps.

Regards,
Damyan Bogoev
the Telerik team

[Patrice Boissonneault]

That is unfortunate, I would like to see this feature too.

[Damyan Bogoev]

Hi Patrice,

Could you please provide us with a feature list, which shows the missing functionality in the OpenAccess ORM logging?

We will consider it as a future improvement in the product.

I am looking forward to hearing from you.

Regards,
Damyan Bogoev
the Telerik team

[Bryan]

I too would like to see the ability to integrate with MiniProfiler.

[Damyan Bogoev]

Hello Bryan,

Currently an integration with the MiniProfiler is not on our to-do list.

If this is important to you, please feel free to add an entry to our Ideas & Feedback portal.

All the best,
Damyan Bogoev
the Telerik team

[Joshua]

The OA Profiler is great for tuning Query performance in isolation, however; it falls short when devs want to monitor app performance as a whole.  In addition, MiniProfiler allows anyone to keep tabs on app performance, not just developers with the profiler installed.

The missing feature is Context, which can only be provided by something running in app.  Its not that the OA profiler isn't great, it is :), the issue is that it does not provide the same answers, and passive perf monitoring, MiniProfiler does. 

-Josh

[Alexander]

Hello Josh,

You are correct, the target of the OpenAccess Profiler is measuring query performance and suggesting optimizations to the domain model and the way it is used.
Integration with MiniProfiler seems useful, however it is currently with low priority in our backlog. We will need to get more requests for it before the implementation is started, as it would require exposing some internal parts of our API and other not so trivial changes.
Thank you for your feedback.

Greetings,
Alexander
the Telerik team

[Primoz Krajnik]

+1

Dear Telerik friends, here's my vote to climb MiniProfiler up the backlog.


Thanks,
primož

[Joshua]

Hi All,
I added the request to the feedback portal.  Make sure to place your votes here: http://feedback.telerik.com/Project/114/Feedback/Details/46909-enable-integration-with-miniprofiler

-Josh