Microsoft: SQL Server PowerPack, Release Notes version 101

Version 101 of the Microsoft: SQL Server PowerPack includes updates to Dynamic Applications.

  • Minimum Required SL1 Version: 10.2.0

Before You Install or Upgrade

Ensure that you are running version 10.2.0 or later of SL1 before installing "Microsoft: SQL Server" PowerPack version 101.

For details on upgrading SL1, see the relevant SL1 Platform Release Notes.

Installation and Upgrade Process

By default, installing a new version of a PowerPack will overwrite all content in that PowerPack that has already been installed on the target system. You can use the Enable Selective PowerPack Field Protection setting in the Behavior Settings page (System > Settings > Behavior) to prevent the new version of the PowerPack from overwriting local changes for some commonly customized fields.

If you are currently using the Dynamic Applications in the PowerPack to monitor devices, collection errors might occur for one or two polling cycles during the installation of a new version. To prevent collection errors during an upgrade, you can optionally disable collection for monitored devices before performing the following steps and re-enable collection after the upgrade.

To install this PowerPack:

  1. Search for and download the PowerPack from the PowerPacks page (Product Downloads > PowerPacks & SyncPacks) at the ScienceLogic Support Site.
  2. In SL1, go to the PowerPacks page (System > Manage > PowerPacks).
  3. Click the Actions menu and choose Import PowerPack. The Import PowerPack modal appears.
  4. Click Browse and navigate to the PowerPack file from step 1.
  5. Select the PowerPack file and click Import. The PowerPack Installer modal displays a list of the PowerPack contents.
  6. Click Install. The PowerPack is added to the PowerPack Manager page.

Features

This release includes the following features:

  • Dynamic Applications that discover, model, and collect performance and configuration data for Microsoft SQL Server devices
  • Event Policies that are triggered when Microsoft SQL Server devices meet certain status criteria

Enhancements and Issues Addressed

The following enhancements and addressed issues are included in version 101 of the "Microsoft: SQL Server" PowerPack:

  • The "Microsoft: SQL Database Performance" Dynamic Application was updated to address an issue in which the "Percent Processor Time" collection object was collecting incorrect data on multi-core servers. (Support Case: 00058607; JIRA ID: SOL-4306)
  • The following collection objects in the "Microsoft: SQL Database Performance" Dynamic Application were updated to use multi-series metrics:
  • Percent Processor Time
  • Private Bytes
  • Working Set
  • All Dynamic Applications in the PowerPack were updated to have the Collector Affinity field set to Assigned collector by default.
  • The "Microsoft: SQL 2008 Buffer Pages Performance Dynamic Application was removed from the PowerPack.

Known Issues

This release has no known issues.