Skip to main content
All CollectionsGeneralDBaaS
What performance insights does Tessell provide
What performance insights does Tessell provide
Bakul Banthia avatar
Written by Bakul Banthia
Updated over a week ago

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:

  1. Oracle

  2. SqlServer

  3. Postgres

  4. MySQL

Features

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

    1. Active Sessions

      1. An active session is a connection that has submitted work to the DB engine and is waiting for a response.

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

    2. Average Active Sessions

      1. It measures how many sessions are concurrently active on the database on average within a given timeframe.

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

  2. Top Dimensions

    1. Top dimensions are the dimensions of the data corresponding to the DB Load within a given timeframe. These include:

      1. Top Waits:

        1. These are the top waits by db load on which database was waiting upon in a given timeframe

      2. Top SQLs

        1. These are the top sql queries by db load running on the database in a given timeframe masked and grouped by their type.

      3. Top Hosts

        1. These are the top hosts that were contributing to most of the db loadon the database in a given timeframe

      4. Top Users

        1. These are the top users that were contributing to most of the db load on the database in a given timeframe

      5. Top Databases

        1. These are the top users that were contributing to most of the db load on the database in a given timeframe

  3. Default data retention: 7 days

Did this answer your question?