Version 102 of the Microsoft: SQL Server PowerPack includes updates to Dynamic Applications.
- Minimum Required SL1 Version: 11.3.0
Before You Install or Upgrade
Ensure that you are running version 11.3.0 or later of SL1 before installing "Microsoft: SQL Server" PowerPack version 102.
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.
If you are currently using the Dynamic Applications in this 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:
- Search for and download the PowerPack from the PowerPacks page (Product Downloads > PowerPacks & SyncPacks) at the ScienceLogic Support Site.
- In SL1, go to the PowerPacks page (System > Manage > PowerPacks).
- Click the Actions menu and choose Import PowerPack. The Import PowerPack modal appears.
- Click PowerPack file from step 1. and navigate to the
- Select the PowerPack file and click . The PowerPack Installer modal displays a list of the PowerPack contents.
- Click PowerPack is added to the PowerPack Manager page. . The
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 this release of the "Microsoft: SQL Server" PowerPack:
- Addressed an issue in which regional settings that use a comma for decimal format caused data loss and errors when performing a query on the "Microsoft: SQL Database Performance" Dynamic Application. You can now convert values to a string and replace , with . to return data in the expected format.
- Dynamic Applications were updated to replace diacritic characters in Instance and Database names with a corresponding ASCII value or drop the character if there is no match.
Known Issues
The following known issues affect version 102 of the Microsoft: SQL Server PowerPack:
- The Microsoft: SQL Server PowerPack does not support the constrained language.
- Get-Counter errors may appear, and collection may be affected for some Dynamic Applications when the performance counter cannot be found. To address this you will need to rebuild the performance counter manually. See the documentation at Microsoft to rebuild the performance counter here: https://learn.microsoft.com/en-us/troubleshoot/windows-server/performance/manually-rebuild-performance-counters
- Historical data may be affected after Concurrent PowerShell is enabled. However, Dynamic Applications will work and collect data properly after this function is allowed.