Skip to main content
Sumo Logic

Install the Microsoft SQL Server App and view the Dashboards

Install the Sumo Logic App

Now that you have configured SQL Server, install the Sumo Logic App for Microsoft SQL Server to take advantage of the preconfigured searches and dashboards to analyze your data. 

To install the app:

  1. Select App Catalog, search for and select the app, and click Add to Library. (In the classic UI, click Library, click Apps, select the app, and click Install. If you don't find the app under Apps, it might be a preview app. Try clicking Preview to find the app.)
  2. Click Preview Dashboards if you'd like to see a preview of the dashboards included with the app before installing.
  3. In the Install Application dialog box, select the installation path (the default is the Personal folder in the library), or click New Folder to add a new folder.
  4. Select either of these options for the log data source.
  • Choose Select from Existing Source Categories, and select the source catalog from the Source Category list.
  • Choose Enter a Custom Data Filter and enter a custom source category beginning with an underscore. Example: (_sourceCategory=MyCategory).
  1. 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 in the new UI.

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

SQL Server - Overview

Top 10 Logged-on Active Users. Shows the top 10 logged-on active users by username and login count in an aggregation table for the last hour.

Top 10 Logged-on Active IP Addresses. Displays the top 10 logged-on active IP addresses by client IP and login count in an aggregation table for the last hour.

Logon Authentication Method Used. Provides information on the logon authentication methods used in a stacked column chart using one hour timeslices for the last 24 hours.

Logon Failures. Shows logon failure numbers in a stacked column chart using one hour timeslices for the last 7 days.

Logon Failure Reason. Displays logon failure count and reasons in a pie chart for the last 7 days.

Deadlock Count. Shows the deadlock error count in a single value chart for the last 24 hours.

SQL Server - Backup Restore Mirroring

Transaction Log Backed Up. Provides information on transaction log backup events in a column chart on a timeline using a timeslice of one day for the last 7 days.

Database Backed Up. Displays information on database backup events in a column chart on a timeline using a timeslice of one day for the last 7 days.

Restore Activity. Shows information on restore activity in a stacked column chart on a timeline using a timeslice of one day for the last 7 days.

Backup Failures. Provides details on backup failures in a column chart on a timeline using timeslices of one day for the last 7 days.

Backup Failure Reasons. Displays backup failure reasons in an aggregation table with the reason text and count for the last 7 days.

Mirroring Errors. Shows information on mirroring errors in a stacked column chart on a timeline using a timeslice of one day for the last 7 days.

SQL Server - DB Monitor

DB Space % Utilization. Displays database space utilization in percentage in a line chart on a timeline using a utilization in percentage in a line chart on a timeline using a timeslice of one hour for the last 7 days.

DB Size. Provides information on the database size in MB in a line chart on a timeline using a timeslice of one hour for the last 7 days.  

Wait Time Trend. Shows the wait time trend in a stacked column chart  using a timeslice of 5 minutes on a timeline for the last hour.

SQL Server - General Health

Stopped Servers.Shows information on stopped servers in an aggregation table with details on the host, event time, server status, and remarks for the last 7 days.

Up Servers.Displays information on servers that are up and running in an aggregation table with details on the host, event time, server status, and remarks for the last 7 days.

Server Up-Down Events Trend.Shows information on server up and down events in a stacked column chart on a timeline using timeslices of one hour for the last 7 days.

Deadlocks. Displays server deadlock error events in a column chart on a timeline using timeslices of one day for the last 7 days.

AppDomain Issues. Provides information on AppDomain error events in a column chart on a timeline using timeslices of one day for the last 7 days.

Insufficient Space Issues. Shows information on insufficient space issues in a column chart on a timeline using timeslices of one day for the last 7 days.

SQL Server - Operations

Recent Configuration Updates. Displays details on recent server configuration changes in an aggregation table with information on the time, host, object, old value, and new value for the last hour.

Configuration Updates. Shows information on the number and type of server configuration updates in a pie chart for the last 24 hours.

Configuration Update Trend. Provides the configuration update trend in an area chart on a timeline using a timeslice of one hour for the last 24 hours.

Error and Warning. Displays error and warning events in a pie chart for the last 24 hours.

High Severity Error Trend. Shows the high severity error trend as a stacked column chart on a timeline using a timeslice of one day for the last 14 days.

Error and Warning Log Type Trend. Provides the error and warning log type trend as a stacked column chart on a timeline using a timeslice of one day for the last 14 days.