This video will present to you a few easy steps for enabling the OpenAccess ORM logging functionality for your application and using the logs later to analyze the performance with the OpenAccess Profiler.
Performance is always an important concern when you are using third-party products for your data access. For that reason Telerik OpenAccess ORM is offered together with the OpenAccess Profiler and Tuning Advisor application, included in the installation. It can monitor your SQL and LINQ statements, warn you for possible problems and helps you to fix them.
Telerik OpenAccess Profiler and Tuning Advisor is a graphical user interface for monitoring of all the OpenAccess activity in your application. For example, you can monitor a production environment to see which queries are affecting performance by executing too slowly.
Starting the OpenAccess Profiler
You could start the OpenAccess Profiler via the Telerik->OpenAccess->Profiler and Tuning Advisor menu command.
Or, you could start the profiler directly from the OpenAccess installation directory (~\Telerik\OpenAccess ORM\bin\Telerik.OpenAccess.Profiler.exe).
Two Views For Displaying Information
OpenAccess ORM produces two different kinds of data - metrics and events. Metrics are similar to the operating system counters. They produce snapshots of the system status like counting insert, update and delete statements per second. Log events contain the real operation information, including query parameters and stack traces. The OpenAccess Profiler provides views for both data types - Events View and Metrics View. The Events View is the default view you are going to see when you start the OpenAccess Profiler for first time. You could switch to the Metrics View by using the Metrics View Toolbar Command.
Saving the Trace Data Locally
The OpenAccess Profiler allows you to store the trace data locally for analysis - just be clicking the Save button you will have the trace saved in a file you choose.
Two Ways For Monitoring Your Application
The OpenAccess Profiler allows you to monitor your application in two different ways:
- Offline monitoring - you can capture and save data about each event to a file to analyze later.
- Real-time (live) monitoring - you can download a real-time data via an OpenAccess implemented web service.
Both ways can be used in parallel to generate and store the data. The following topics describe how both ways have to be configured:
The topics in this section show how to work with the OpenAccess Profiler: