Skip to main content
Sumo Logic

Install the Azure SQL App and View the Dashboards

Instructions for installing the Sumo Logic App for Azure SQL, and descriptions of the app dashboards.

Install the Sumo Logic App 

Now that you have set up collection of Azure SQL logs and metrics, install the Sumo Logic App for Azure SQL to use the pre-configured searches and dashboards.
 
To install the app

Locate and install the app you need from the App Catalog. If you want to see a preview of the dashboards included with the app before installing, click Preview Dashboards.

  1. From the App Catalog, search for and select the app. 
  2. To install the app, click Add to Library.
    install-azure-sql.png
  3. App Name. You can retain the existing name, or enter a name of your choice for the app.

  4. Azure SQL Metrics Source. Select the source category that you configured for the .... source. 
  5. Azure SQL Log Source. Select the source category that you configured for the ... source.
  6. Advanced. Select the Location in Library (the default is the Personal folder in the library), or click New Folder to add a new folder.
  7. Click Add to Library.

Once an app is installed, it will appear in your Personal folder, or other folder that you specified. From here, you can share it with your organization. See Welcome to the New Library for information on working with the library.

Panels will start to fill automatically. It's important to note that each panel slowly fills with data matching the time range query and received since the panel was created. Results won't immediately be available, but with a bit of time, you'll see full graphs and maps.

Dashboards

This section describes the dashboards in the Sumo Logic App for Azure SQL.

Azure SQL - Overview

See the count of logical servers, databases, errors; and the “top 10” active servers, resource groups, subscriptions, resources, databases, operations, and categories. 

azure-sql-overview.png

Logical Servers. The count of logical servers over the last 24 hours.

Databases. The count of databases over the last 24 hours.

Errors. The count of errors over the last 24 hours.

Error Severity. A donut chart that shows the breakdown of errors by severity over the last 24 hours.

Lock Duration. The total number of seconds that the database experienced locks in the last 24 hours.

Active SQLInsights. The count of performance issues detected by SQL Insights whose current status is “Active”.

Top 10 Active Logical Server Names. The names of the 10 logical servers that have experienced the most events over the last 24 hours, and the event count for each. 

Top 10 Active Server, Databases. Lists the 10 logical server-database combinations that have experienced the most events over the last 24 hours, and the event count for each. 

Top 10 Active Resource Groups. Lists the 10 active resource groups that have experienced the most events over the last 24 hours, and the event count for each. 

Top 10 Active SubscriptionId. Lists the 10 active SubscriptionIds that have experienced the most events over the last 24 hours, and the event count for each. 

Top 10 Active ResourceId. Lists the 10 active ResourceIds that have experienced the most events over the last 24 hours , and the event count for each.

Top 10 Active Server, Databases and Elastic Pool. Lists the 10 logical server-database-elastic pool combinations that have experienced the most events over the last 24 hours, and the event count for each.

Top 10 Operations. Lists the 10 operations with the most events over the last 24 hours.

Top 10 Active Server, Databases and WaitType.  Lists the 10 logical server-database-wait type  combinations that have experienced the most events over the last 24 hours, and the event count for each.

Top 10 Categories.The top 10 log categories for Azure diagnostic logs emitted over the last 24 hours.

Operations Trend. A stacked bar chart that shows the count of different operations over the last 24 hours.

Azure SQL - Blocking Stats

See information about blocking queries in Azure SQL, including lock mode usage, lock duration, and details about block events. 

azure-sql-blocking-stats.png

Lock Mode Used by Query. A donut chart that shows the breakdown of lock modes for blocked queries over the last 7 days.

Owner Type Used by Query. A donut chart the shows the breakdown of resource owner types for blocked queries over the last 7 days.

Lock Duration. The total number of seconds that database updates were blocked over the last 7 days.

Block Event Details. A table that lists details for blocking events over the last 7 days.

Blocks by Database. A table that lists the count of blocking events and the total lock duration by logical server and database over the last 7 days.

Blocks by Database Trend. A bar chart that shows the total lock duration by logical server and database on a timeline for the last 7 days.

Azure SQL - DatabaseWait Stats
Wait Events by Database. A donut chart that shows the count of wait events by logical server-database combination over the last 24 hours.

Wait Events Breakdown by Database. A stacked bar chart that shows the breakdown of wait events by wait type on a timeline over the last 24 hours. 

Wait Type Trend. A stacked column chart that shows wait event over time, broken down by wait type.

Average Wait Time Per Task. A table that lists task-level information about wait events by logical server-database-wait type combination over the last 24 hours, including the count of waiting tasks, total wait time for those tasks, and the average wait time per task.

Detailed Stats. A table that lists information about wait events in the last 24 hours.

Azure SQL - Errors

See information about errors in Azure SQL, including total error count, top 10 error numbers and error messages, errors by severity and database, error trend and comparison analyses, and error details.

azure-sql-errors.png

Errors. Count of errors over the last 24 hours.

Top 10 Errors. A table that lists the top 10 error numbers over the last 24 hours and the count of each error number. 

Errors by Severity. A table that lists the severity of errors over the last 24 hours and the count of errors with each severity.

Errors by Database. A table that lists the error count for each database over the last 24 hours.

Error Trend. A stacked bar chart that shows the count of each error number over time.

Errors - One Day Time Comparison. A line chart that shows the count of errors per timeslice over the last 24 hours, compared with the count of errors one day previous.

Distinct Error Messages - One Day Time Comparison. A line chart that shows the count of distinct errors (unique messages) per timeslice  over the last 24 hours, compared with the same count one day previous.

Top 10 Error Messages. A table that lists the top 10 error messages, and the count of each over the last 24 hours.

Error Details. A table that lists the details of errors that occurred during the previous 24 hours.

Azure SQL - Metrics

See metrics for connections attempts; Database Transaction Unit (DTUs), CPU and storage utilization; and for deadlocks, sessions, and workers. 

For information about the metrics presented in the Metrics dashboards, see All metrics and Microsoft.Sql/servers/databases in Azure help.

azure-sql-metrics.png

Blocked by Firewall. A line chart showing the count of connections blocked by a firewall over the last 24 hours. 

Connection Failed. A line chart showing the count of failed connections over the last 24 hours. 

Successful Connection. A line chart showing the count of successful connections over the last 24 hours. 

Blocked by Firewall Per Database. A line chart showing the count of connections to each database blocked by a firewall over the last 24 hours. 

Connection Failed Per Database. A line chart showing the count of failed connections to each database over the last 24 hours.

Successful Connection Per Database. A line chart showing the count of successful connections to each database over the last 24 hours.

DTU Limit Per Database. A line chart showing the Database Throughput Unit (DTU) limit for each database over the last 24 hours.

DTU Used Per Database. A line chart showing the DTU used for each database over the last 24 hours.

DTU Consumption Percent Per Database. A line chart showing the percentage of the DTU limit was consumed by each database over the last 24 hours.

Avg CPU Utilization Percent Per Database. A line charge showing the average percentage of CPU used by each database over the last 24 hours.

Max CPU Utilization Percent Per Database. A line charge showing the maximum percentage of CPU used by each database over the last 24 hours.

Storage Per Database. The total size in bytes of each database over the last 24 hours.

Storage Percent Per Database. The percentage of the maximum allowed database size used by each database over the last 24 hours.

XPT Storage Percent Per Database. The percentage of in-memory OLTP storage used by each database over the last 24 hours.

Deadlocks. Count of deadlocks over the last 24 hours.

Sessions Percent Per Database. The percentage of allowed sessions used by each database over the last 24 hours.

Physical Data Read Percent. Displays average data I/O percentage over the last 24 hours.

Deadlocks Per Database. Count of deadlocks by database over the last 24 hours.

Workers Percent Per Database. The percentage of the allowed workers  used by each database over the last 24 hours.

Log Write Percent. Displays average log I/O percentage over the last 24 hours.

Azure SQL - QueryStoreRuntime Stats

See query runtime execution statistics such as CPU usage and query duration.

For more information about the statistics presented on the QueryStoreRuntime Stats dashboard, see Query Store runtime statistics in Azure help.

azure-sql-querystoreruntime-stats.png

Unique QueryId's. The count of unique queryIDs over the last 24 hours.

Unique PlanId's.The count of unique PlanIDs over the last 24 hours.

Top Queries by High Execution Time. A table that lists the 15 queries with the longest execution time over the last 24 hours, and information about those queries.

Execution Count by DatabaseName. A line chart that shows the count of queries per timeslice for each database over the last 24 hours.

Execution Duration by DatabaseName. A line chart that shows the total duration (in milliseconds) of queries per timeslice for each database over the last 24 hours.

Memory Used by DatabaseName. A line chart that shows the maximum memory used per timeslice by each database over the last 24 hours.

CPU Time by DatabaseName. A line chart that shows the CPU time consumed (in microseconds) by queries per timeslice by each database over the last 24 hours.

Execution Count of Query. A stacked column chart that shows the count of each query per timeslice over the last 24 hours. 

Execution Duration of Query. A stacked column chart that shows the total execution time in milliseconds for each query per timeslice over the last 24 hours. 

Rows Returned by Query. A stacked column chart that shows the rows returned by each query per timeslice over the last 24 hours. 

CPU Time by Query. A stacked column chart that shows the CPU time used by each query per timeslice over the last 24 hours. 

Memory Used by Query. A stacked column chart that shows the memory used by each query per timeslice over the last 24 hours. 

Max Degree of Parallelism by Query. A stacked column chart that shows the maximum degree of parallelism for each query per timeslice over the last 24 hours.

Physical IO Reads by Query. A stacked column chart that shows the count of reads from disk for  each query per timeslice over the last 24 hours.

Logical IO Reads by Query. A stacked column chart that shows the count of reads from memory for each query per timeslice over the last 24 hours.

Log Bytes Used by Query. A stacked column chart that shows the count bytes written to the transaction log for each query per timeslice over the last 24 hours.
 
Execution Type of Query. A stacked column chart that shows the count of queries by execution type: Regular, Aborted, or Exception over the last 24 hours.

Azure SQL - QueryStoreWait Stats

See information about how much time a database spent waiting on different wait types.

For more information about the statistics presented on the QueryStoreWaitStats dashboard, see Query Store wait statistics in Azure help.

azure-sql-querystorewait-stats.png

Wait Category. A donut chart that shows the breakdown of wait events by database over the last 24 hours.

Wait Category Breakup. A horizontal bar chart that shows the breakdown of wait event by category for each database over the last 24 hours.
 
Max Query Wait Time by DatabaseName. A line chart that shows that maximum query wait type per timeslice for each database over the last 24 hours.

Wait Category Trend. A stacked column chart that shows the count of wait events by category per timeslice over the last 24 hours.

Total Wait Time for Query by Wait Category. A stacked column chart that shows, for each query, the length of time a query spent waiting in each Wait Category over the last 24 hours.  

Wait Details. The table displays wait statistics as encountered by queries on a given database, residing on a given logical server in the last 24 hours. 

Azure SQL - SQLInsights

See database performance analytics obtained from Azure SQL Database Intelligent Insights, including information about issues like excessive wait times, critical exceptions, and so on.

For more information about the data presented on the SQLInsights dashboard, see Use the Intelligent Insights Azure SQL Database performance diagnostics log in Azure help.

azure-sql-sqlinsights.png

Active SQLInsights.  Count of active SQL Insights issues as of the current time.

Unique Issues. Count of issues identified, whether resolved or not.

Latest Issue Status. Displays count of issues with latest state and root cause.

Insight Metric. Displays the performance metric for which an issue is identified, by IssueID.

Issues by Database. A table that shows the count of unique issues by database over the last 7 days.

Issue State. A table that shows the current state of unique issues, along with additional information about the issues over the last 7 days.

Issue Details. Displays information about the progress of issues throughout the resolution process.

Azure SQL - Timeouts

See information about timeouts in Azure SQL. 

For more information about the data presented on the Timeouts dashboard, see Time-outs dataset in Azure help.

azure-sql-timeouts.png

Timeouts. The count of timeouts over the last 7 days.  

Top 10 Error States. A table that lists the top 10 errors states that have occurred over the last 7 days and the count of errors in each state.

Timeouts by Database. A table that lists the count of timeouts by database over the last 7 days.

Timeouts Details. A table that lists information about timeouts that have occurred over the last 7 days.