Skip to main content
Sumo Logic

Install the Microsoft SQL Server App and view the Dashboards

This page provides instructions for installing the Microsoft SQL Server App, as well as examples of each of the App dashboards.

Install the Sumo Logic App

Now that you have configured SQL Server collection, 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, do the following:

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 and complete the following fields.
    1. App Name. You can retain the existing name, or enter a name of your choice for the app.

    2. Data Source. Select either of these options for the data source.

      • Choose Source Category, and select a source category from the list.

      • Choose Enter a Custom Data Filter, and enter a custom source category beginning with an underscore. Example: (_sourceCategory=MyCategory).

    3. Advanced. Select the Location in Library (the default is the Personal folder in the library), or click New Folder to add a new folder.
  3. 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. 

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

sql_server_app_overview.png

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

sql_server_app_backup_restore.png

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

sql_server_app_db_monitor.png

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

sql_server_app_general_health.png

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

sql_server_app_operations.png

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.