• Phone: +1-425-502-5094
  • info@deevita.com

The Business Problem

  • During performance troubleshooting – Have you ever desired for a quicker process to follow, especially when your system had slowed down and when the business is being impacted?
  • Have you wished to compare the execution plans for a different time frame query easily?
  • Have you wished to regress the query plan quickly instead of going through a lengthy process of using a plan guide?
  • Have you wished if the query execution plans didn't lose track even after a server restart or upgrade?

Deevita's Solution

  • Our dashboard provides basic reports. Besides, it enables users to understand the key metrics of SQL performance and identify the regressed queries. Also, there is a drill-through capability for deep-dive analysis.
  • As a DBA, you might have been executing performance troubleshooting for a long, irrespective of SQL Server versions
  • The dashboard is integrated with the SQL Server engine, so it captures information (such as queries executed, execution plans followed, statistics related to aggregated query run time) asynchronously. This feature ensures there is only very minimal impact.
  • The dashboard follows the captured information in internal database tables for later use. Consequently, you can fetch this information even after a server restart (which is unlikely during a regular operation when a plan cache is stored in memory, and information can get lost after server restart)

Benefits

This dashboard can be easily configured to an existing Azure SQL Database, and you can enable these features for a specific Azure SQL DB which requires performance troubleshooting.

  • To know what sort of workloads your customers are using – the dashboard captures query text and the query execution plan
  • To understand the top 'n' queries in terms of query execution time, I/O, memory consumption, etc. You can also find the top queries on an hourly basis
  • To find queries that have a high run time variance with respect to time
  • To identify the number of times a query was executed in each time frame
  • To discover the queries that have changed plans since time
  • To analyze resource utilization (such as CPU, Memory, I/O) by the database (for which this feature has been activated)
  • To determine the history of query plans for a specific query
  • To audit the query cost so you can ensure the performance SLA, or you can even evaluate the capacity needs of an application and find the resource contention
  • To quickly find a plan performance regression by executing the previous query plan which was believed to be performing better than a newly generated plan
  • To fix queries that have recently regressed in terms of performance due to the changes in execution plan after recent upgrades or any other changes

Unlock the Full Power of the Dashboard

You can do Query-level analytics to know the minimum, average and maximum performance variations of each Azure SQL queries. Options to quickly drill through the queries according to their execution status, such as, ‘Completed’, ‘Cancelled’, ‘Failed’.

Basic Version vs Full Version

Azure SQL DB Basic Dashboard


1) DB Performance over a time period


2) Shows only the performance metric on a total basis


3) NO options to drill through the queries according to their execution status

4) Ability to see Plan IDs for a specific date only

Azure SQL DB Advanced Dashboard


1a) DB Performance over a time period
1b) Added Query-specific analysis

2) Besides showing the performance metric on a total basis, the minimum, average and maximum metrics can also be fetched

3) HAS options to drill through the queries according to their execution status

4) Ability to see Plan IDs for over a range of dates

Contact Details

Please find below contact details
and contact us today!

  • Phone: +1-425-502-5094
  • Email: info@deevita.com
  • Mon to Fri: 9.00am to 6.00pm PST

Request For Call Back