Microsoft SQL Server Enhanced: SL1 Dashboards PowerPack Release Notes, version 102

Version 102 of the Microsoft: SQL Server Enhanced SL1 Dashboards PowerPack includes autoselect for context-driving widgets and the addition of the Events and Buffer Cache Hit Ratio Forecast widgets.

NOTE: These dashboards are intended for use only in the new user interface for SL1 and will not load in the classic ScienceLogic platform user interface.

  • Minimum Required SL1 Version: 8.12.1
  • Minimum Required AP2 Version: 5.125.44
  • Minimum Required Widget Components Version: 2.175.0
  • Minimum Required Microsoft: SQL Server PowerPack version: 100

Before You Install or Upgrade

Before installing Microsoft: SQL Server Enhanced SL1 Dashboards PowerPack version 102, you must first ensure that you are running version 8.12.1 or later of SL1.

NOTE: For details on upgrading SL1, see the appropriate Release Notes.

You must also import and install theMicrosoft: SQL ServerPowerPack version 100 or later before installing the PowerPack.

Installation or Upgrade Process

To install this PowerPack:

  1. Familiarize yourself with the Known Issues for this release.
  2. See the Before You Install or Upgrade section. If you have not done so already, upgrade your system to the 8.12.1 or later release.
  3. Download the "Microsoft: SQL Server Enhanced SL1 Dashboards" version 102PowerPack from the Support Site to a local computer.
  4. Go to the PowerPack Manager page (System > Manage > PowerPacks). Click the Actions menu and choose Import PowerPack. When prompted, import "Microsoft: SQL Server Enhanced SL1 Dashboards" version 102.
  5. Click the Install button. For details on installing PowerPacks, see the chapter on Installing a PowerPack in the PowerPacks manual.

Features

The following dashboards are included in version 102 of the Microsoft: SQL Server Enhanced SL1 Dashboards PowerPack:

  • A "Microsoft: SQL Server Performance" dashboard, which includes the following widgets that display overview data about your SQL servers:
  • SQL Servers
  • Vitals (avg)
  • Latency (avg)
  • Events
  • Bottom 10 - Buffer Cache Hit Ratio (min)
  • Selected Buffer Cache Hit Ratio (avg)
  • Buffer Cache Hit Ratio Forecast (avg)
  • Top 10 - Average Wait Time (max)
  • Selected Average Wait Time (avg)
  • Top 10 - Deadlocks per Second (max)
  • Selected Deadlocks per Second (avg)
  • Top 10 - Lock Waits per Second (max)
  • Selected Lock Waits per Second (avg)
  • Bottom 10 - Catalog Cache Hit Ratio (min)
  • Selected Catalog Cache Hit Ratio (avg)
  • Top 10 - Page Life Expectancy (min)
  • Selected Page Life Expectancy (avg)
  • Top 10 - Transactions per Second (max)
  • Selected Transaction per Second (avg)
  • Top 10 - Latch Waits per Second (max)
  • Selected Latch Waits per Second (avg)

Enhancements and Issues Addressed

The following enhancements and addressed issues are included in version 102 of the Microsoft: SQL Server Enhanced SL1 Dashboards PowerPack:

  • Autoselect for context-driving widgets has been enabled in the "Microsoft: SQL Server Performance" dashboard.
  • The Events and Buffer Cache Hit Ratio Forecast widgets were added to the "Microsoft: SQL Server Performance" dashboard.

Known Issues

Version 102 of the Microsoft: SQL Server Enhanced SL1 Dashboards PowerPack has no known issues.