Microsoft: SQL Server Enhanced Release Notes version 106

Version 106 of the Microsoft: SQL Server Enhanced PowerPack includes updates to a number of Dynamic Applications.

  • Minimum Required SL1 Version: 11.1.2

  • Other Key Information:
  • Additional permissions are required for the user account SL1 uses to perform collection. See the Required Permissions section of this document for more information. If you are currently monitoring devices using the PowerPack, you must update the permissions of the user account you are using to monitor those devices. New Dynamic Applications will be aligned to existing devices during the next discovery of those devices.
  • This version of the PowerPack requires PowerShell version 3.0 or later to be installed on the monitored SQL Servers.
  • The SQL Servers that you monitor must have the SQL Server PowerShell module installed.

Before You Install or Upgrade

Ensure that you are running version 11.1.2 or later of SL1 before installing "Microsoft: SQL Server Enhanced" PowerPack version 106.

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

In addition, ensure that the SQL Servers you want to monitor are running PowerShell 3.0 or later.

Required Permissions

Version 106 of the Microsoft: SQL Server Enhanced PowerPack requires the following permissions for the user account used for monitoring:

  • SQL 2014 and later versions require one of the following configurations:
  • The user account has an enabled login on every instance and database to be monitored, with CONNECT SQL, VIEW SERVER STATE, and CONNECT ANY DATABASE permission granted to the login on each instance. The login should have VIEW DATABASE STATE permission and DB_DATAREADER role granted on the 'master' database, and the DB_DATAREADER role granted on the 'msdb' database.
  • The user account has an enabled login on every instance and has the SYSADMIN role.
  • SQL 2012 requires one of the following configurations:
  • The user account has an enabled login on every instance and database to be monitored, with CONNECT SQL and VIEW SERVER STATE granted to the login on each instance. The login should also have VIEW DATABASE STATE permission and the DB_DATAREADER role granted on the 'master' database, and the DB_DATAREADER role granted on the 'msdb' database. In addition, every database in the instance should have CONNECT access granted to the login.
  • The user account has an enabled login on every instance and has the SYSADMIN role.

Installation and Upgrade Process

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 to discover and monitor SQL servers and their component devices
  • Event Policies that are triggered when SQL Server components meet certain status criteria
  • Device Classes for each type of SQL Server components device monitored
  • An example credential you can use to create PowerShell credentials to connect to SQL servers

Enhancements and Issues Addressed

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

  • Updated the "Microsoft: SQL Server Long Jobs Configuration" Dynamic Application to better handle dates on non-US-based systems. (Support Case: 00323168)
  • Updated the PowerShell request in the "Microsoft: SQL Server Performance" Dynamic Application to always return values with "." as decimal separator. (Support Case: 00242849)
  • Removed the "Deprecated_Snippet"snippet and "Unused_Deprecated" collection object from the "Microsoft: SQL Server Table Lock/Latch Performance" Dynamic Application.
  • Updated the "Microsoft: SQL Server Instance Performance" Dynamic Application to use the "Get-WinEvent" cmdlet to fetch Windows event log records.

Known Issues

The following known issues affect version 106 of the Microsoft: SQL Server Enhanced PowerPack:

  • SQL Server instances with a "$" in the instance name will not discover databases or collect data. The instance name displayed in SL1 will contain only the characters after the "$".
  • The "GetDB-Counters" snippet in the "Microsoft: SQL Server Database Performance" Dynamic Application will not collect data when the performance counter cannot be found. To address this, you will need to rebuild the performance counter manually. See the Microsoft documentation for the steps to rebuild the performance counter: https://docs.microsoft.com/en-us/troubleshoot/windows-server/performance/manually-rebuild-performance-counters
  • The Microsoft: SQL Server Dashboard PowerPack is not compatible with the Microsoft: SQL Server Enhanced PowerPack.
  • The performance Dynamic Applications in the PowerPack do not collect data for SQL Server x86 instances installed on a 64-bit platform.

  • Upgrading to from v103 to v104 may log an exception which includes “get_cached_dictionary - Exception for 8C0F8D1AB88C18E1ADD9DFA4A0D43E50_SqlInventoryCache_52_Me_SqlDatabase.CLUS_INST02.model.52 - __new__() takes exactly 13 arguments (12 given)” The exception does not recur on subsequent collections.