Tessell Performance Insights is a database performance monitoring tool that allows to assess and analyze the load on the database within a specified timeframe. This tool enables users to identify bottlenecks and pinpoint areas where performance improvements are needed.
Supported DB engines:
Oracle
SqlServer
Postgres
MySQL
Features
Database Load: Database load measures the level of session activity in the database. The key metric in Performance Insights is DBLoad, which is collected every second. The unit for database load is the AAS (Average Active Sessions) which is the measure of the average active connections in a specific timeframe.
Active Sessions
An active session is a connection that has submitted work to the DB engine and is waiting for a response.
A session is active when it's either running on CPU or waiting for a resource to become available so that it can proceed. For example, an active session might wait for a page (or block) to be read into memory, and then consume CPU while it reads data from the page.
Average Active Sessions
It measures how many sessions are concurrently active on the database on average within a given timeframe.
Every second, Performance Insights samples the number of sessions concurrently running a query. For each active session, Performance Insights collects the following data:
SQL statement
Session state (running on CPU or waiting)
Host
User running the SQL
Database on which the SQL is running
Performance Insights calculates the AAS by dividing the total number of sessions by the number of samples for a specific time period.
Top Dimensions
Top dimensions are the dimensions of the data corresponding to the DB Load within a given timeframe. These include:
Top Waits:
These are the top waits by db load on which database was waiting upon in a given timeframe
Top SQLs
These are the top sql queries by db load running on the database in a given timeframe masked and grouped by their type.
Top Hosts
These are the top hosts that were contributing to most of the db loadon the database in a given timeframe
Top Users
These are the top users that were contributing to most of the db load on the database in a given timeframe
Top Databases
These are the top users that were contributing to most of the db load on the database in a given timeframe
Default data retention: 7 days