Telerik Data Access 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. Respectively, the Metrics View is the place where you could get visual information about these parameters.
The Telerik Data Access Profiler provides visual information about the following metrics:
- Commits – committed ADO transactions.
- Rollbacks – cancelled ADO transactions.
- Flushes – flushed transactions, all write operations are executed but the transaction is still running.
- Enlists – ADO connection enlistments into a distributed transaction.
- Commit errors – errors during transaction commit operations.
- Flush errors – errors during transaction flush operations.
- Query errors – errors reported from relational server executing SQL operations.
- Fetch errors – errors occurred during ADO read operations.
- Active connections – currently opened and used ADO connections.
- Idle connections – currently opened but unused connections.
- Max Active connections – amount of maximum in parallel used connections.
- Checked connections – amount of connections checked because of it’s age or a former error situation. Each check is an additional client/server call.
- Blocked connection requests – application had to wait for a free connection in the pool because the max active connection count was reached.
- Active – currently used context instances.
- Idle – currently unused but pooled context instances.
- Obtained – amount of created user context instances.
- Max active – maximum parallel context instances used by the application.
Second Level Cache
- Cache hits – objects successfully obtained from the cache.
- Cache misses – objects failed to be obtained from the cache.
- Query cache hits – query results successfully obtained from the cache.
- Query cache misses – query results failed to be obtained from the cache.
Second Level Cache Load (%)
- Object hit – percentage of the successfully obtained objects from the cache.
- Object fill – current load of the object cache (%).
- Query hit – percentage of the successfully obtained query results from the cache.
- Query fill – current load of the query result cache (%).