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.
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.
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.
Review the following video for information on using and setting up the Insight Pack.
IBM Operations Analytics-Log Analysis Insight Packs for Infrastructure- Standard Install License.
Cost: License Fee
- IBM Operations Analytics â€“ Log Analysis version 1.3.0 or above
- Microsoft SQL Server 2012, 2014
- Windows OS Events Insight Pack v22.214.171.124 (for processing the event logs).
- Purchased â€śIBM Operations Analytics-Log Analysis Insight Packs for Infrastructure-Standard 1.1â€ť License for each installed Insight Pack.
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.