Microsoft SQL Server Insight Pack

Posted: June 24, 2015 Modified: October 9, 2015


Overview

The Microsoft SQL Server Insight Pack gives customers support to ingest data from SQL Server logs into IBM Operations Analytics – Log Analysis. They can then use a rich set of analytical dashboards to visualize metadata and derived metrics from log content, along with performing additional queries on the content.

Microsoft SQL Server Events Dashboard
Microsoft SQL Server Events Dashboard

The following dynamic dashboards are provided to help visualize the log data and are added to the Search Dashboards pane.

Microsoft SQL Server Health Dashboard

This dashboard displays the health of database instances based on the number of high severity errors from the datasources specific to SQL Server error log. The four charts of the dashboard display top 5 datasources (as a unique combination of SQL Server Host and Database Instance) that have maximum number of errors and stack dump messages.

Microsoft SQL Server Error Log Dashboard

This dashboard displays the fatal errors, software errors, and user errors for the configured time period. The dashboard also has a chart that displays the number of stack dump messages per database server instance for the configured time period.

Microsoft SQL Server Event Level Dashboard

This dashboard displays event log-level distribution charts for the configured time period. The event logs are filtered to display events from the Windows Application event logs in the Microsoft SQL Server environment that are specific to the Microsoft SQL Server providers.

Microsoft SQL Server Events Dashboard

This dashboard displays distribution charts for the top 10 events (for severe log levels, such as, critical, error, and warning) for the configured time period. Event logs are filtered to display events from the Windows Application event logs in the Microsoft SQL Server environment that are specific to the Microsoft SQL Server providers.

Additional information

The Insight Pack includes support for ingesting and performing metadata searches against the following log files.

  • SQL Server error log: ERRORLOG
  • SQL Server Environment event logs:
    • Application event log: Application

Note: Event logs are processed using Windows OS Events Insight Pack. For more information, see Windows OS Events Insight Pack documentation.

Refer to the User Guide included in the Insight Pack for additional information on the Insight Packs and steps for installing and configuring.

Training Information

Review the following video for information on using and setting up the Insight Pack.


Overview presentation used in the training video.

View US Price & Buy

IBM Operations Analytics-Log Analysis Insight Packs for Infrastructure- Standard Install License.

Released: 11 June 2015
Version: 1.1.0.0
Cost: License Fee
Support: Supported

Resources

Product Information
Product Documentation
Documentation
Forum

Requirements

  • IBM Operations Analytics – Log Analysis version 1.3.0 or above
  • Microsoft SQL Server 2012, 2014
  • Windows OS Events Insight Pack v1.1.0.2 (for processing the event logs).
  • Purchased “IBM Operations Analytics-Log Analysis Insight Packs for Infrastructure-Standard 1.1” License for each installed Insight Pack.

Support

This package is subject to the License terms included with the Insight Pack, along with those displayed upon download.

To report a problem with deploying this entry, entitled customers may contact the country specific IBM support channel, reference the IBM Worldwide Directory. Also use the “Support” link to access the support site for IBM Operations Analytics – Log Analysis information.