Microsoft SQL Server Enhanced SL1 Dashboards PowerPack Release Notes, version 100

Version 100 of the Microsoft: SQL Server Enhanced SL1 Dashboards PowerPack is the initial release of the PowerPack. This version includes Dashboards that present graphical representations of the configuration data and performance metrics that are collected for Microsoft devices by the Microsoft: SQL Server Enhanced PowerPack.

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

  • Minimum Required SL1 Version: 8.8.0
  • Minimum Required AP2 Version: 5.114.6
  • Minimum Required Widget Components Version: 2.168.10
  • Minimum Required Apcon PowerPack Version: 100

Before You Install

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

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

You must also import and install the Microsoft: SQL Server Enhanced PowerPack version 101 or later before installing this PowerPack.

Installation 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.8.0 or later release.
  3. Download the "Microsoft: SQL Server Enhanced SL1 Dashboards" version 100PowerPack 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 100.
  5. Click the Install button. For details on installing PowerPacks, see the chapter on Installing a PowerPack in the PowerPacks manual.

Included Features

The following dashboards are included in this version of the PowerPack:

  • A "Microsoft: SQL Server Enhanced Performance" dashboard, which includes the following widgets that display overview data about your SQL servers:
  • SQL Server Instance List
  • Selected SQL Server Database List
  • Instance Session Rates
  • Database Utilization
  • Instance Times
  • Database Size
  • Instance Memory
  • Instance Buffer Rates
  • Instance Counts
  • Database Rates
  • Instance Table Lock/Latch Rates
  • Instance Hit Ratios
  • Database Counts
  • Database Ratios

Known Issues and Workarounds

  • Dashboard widgets might be slow to load or display red bells. If this occurs, you can do the following to address the issue:

  • Start an SSH session into your SL1 appliance.

  • At the shell prompt, enter the following to open the em7_limits.conf file for editing:

    cd /etc/nginx/conf.d

    sudo cp em7_limits.conf em7_limits.conf.backup

    sudo vi em7_limits.conf

  • Locate the line that begins with "limit_req zone=addr_req" and update it to the following:

    limit_req zone=addr_req burst=5000 nodelay;

  • Locate the lines that begin with "limit_conn" and update them to the following:

    limit_conn perip 10000;

    limit_conn perserver 10000;

  • Restart nginx. To do this, enter the following at the shell prompt:

    sudo systemctl restart nginx

  • Dashboards might not appear immediately in the SL1 user interface after you import the PowerPack using the PowerPack Importer. If this occurs, you can do the following to address the issue:

  • Type the following URL into your web browser:

    https://<hostname or ip>/gql?query=mutation%20%7B%20importContentObjectsFromPowerPackQueue%20%7D%0A

  • When prompted, enter your user credentials.
  • Click the GraphQL "play" button. If successful, a "true" message appears in the right-hand panel.
  • Verify that the dashboards now appear by returning to the Dashboards page and refreshing your web browser.