Skip to main content
Sumo Logic

Microsoft SQL Server App 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.