New MP: Microsoft System Center Management Pack for SQL Server


 

 

Management Pack for SQL Server provides the capabilities for Operations Manager 2007 R2, Operations Manager 2012, and Operations Manager 2012 R2 to discover SQL Server 2008, 2008 R2, and 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.

 

Download HERE

 

Note:There are multiple files available for this download.Once you click on the “Download” button, you will be prompted to select the files you need.

 

image

 

    • Management pack for SQL Server provides the capabilities for Operations Manager 2007 R2, Operations Manager 2012 SP1, and Operations Manager 2012 R2 to discover SQL Server 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
      The monitoring provided by this management pack includes performance, availability, and configuration monitoring, along with performance data collection, and default thresholds. You can integrate the monitoring of SQL Server components into your service-oriented monitoring scenarios.
      In addition to health monitoring capabilities, this management pack includes dashboard views, diagram views and extensive knowledge with embedded inline tasks, and views that enable near real-time diagnosis and resolution of detected issues.
      Note: If you are going to localize this management pack, keep in mind that localization installers on this page do not include files for localizing SQL Server Dashboards. Please use this link to download the required localization for Dashboards.
      Feature Summary
      The following list gives an overview of SQL Server management pack features. Refer to SQL Server management pack guide for more details.
    • Discovery and monitoring of SQL Server 2008, 2008 R2 and 2012 roles like DB Engine, Integrations Services.
    • Discovery of SQL Server 2008, 2008 R2 and 2012 components: Databases, SQL Agent and SQL jobs.
    • Monitoring of SQL Server 2012 Always On:
      • Automatic discovery and monitoring of availability groups, availability replicas, and availability databases.
      • Health roll-up from availability database to availability replicas.
      • Detailed knowledge for each related monitoring workflow.
    • Seamless integration with SQL Server policy based management (PBM):
      • Automatic discovery and monitoring of custom PBM polices targeted to Database or Database components.
      • Rollup of policy execution health to the health of related SCOM entity.
    • Low-privilege monitoring is supported for both stand-alone installations and clustered environments, except PBM.
    • Support of Mirroring Monitoring for SQL Server 2008, 2008 R2 and 2012
      • Discover mirroring databases, witness, and mirroring group.
      • Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
      • Custom diagram view to represent the primary and the mirrored databases visually.

    New Features and Fixes

    • Added support for configurations where computer host names are longer than 15 symbols
    • Added “Event ID” to descriptions of all the alerts generated by the alerting rules
    • Added support for databases stored on SMB Shares
    • Updated the visualization library
    • Removed files of SQL 2005 MP from the installer since this MP is no longer supported
    • Added 2 rules for alerts generating when there are problems with execution of the monitoring workflows scripts on the following agents: “MSSQL: Monitoring failed” and “MSSQL: Monitoring warning”
    • Added “MSSQL 20XX: Discovery warning” rules to generate alerts when there are non-critical problems with execution of the discovery scripts (warning events in the Operations Manager log)
    • Changed “MSSQL 20XX: Discovery failed” rules to generate alerts for only critical errors during executing discovery scripts
    • Improved error logging in the MP scripts
    • Fixed issue: SQL Server 2012 Always On discoveries fail after stopping WSFC service
    • Fixed issue: “Set DB offline” task does not work when the database is in Availability Group
    • Fixed issue: user policy discovery script fails with “Invalid namespace “ROOT\Microsoft\SqlServer\ComputerManagement12” error
    • Fixed issue: Always On console task does not work
    • Deprecated “Run As Account does not exist on the target system, or does not have enough permissions” rule
    • Fixed some issues in the scripts, which could lead to unstable work with WMI
    • Fixed error logging in a script for Blocking Sessions monitor
    • Fixed issue: CPU Usage monitor and rule did not work for SQL Server cluster instance
    • Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
    • Fixed Non-Readable Replica detection (Always On)
    • Made detection condition stricter for DB User Policy event-based discovery: added management group name
    • Made detection condition stricter for Script Failed alerting rule: added management group name
  • System Requirements

    Supported Operating System

    Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2

      For detailed system requirements refer to the management pack guide.
  • Install Instructions
      For detailed instructions on setup, configuration, and monitoring refer to the management pack guide.
  • Related Resources
  •  

    Inside the Management Pack Guide:

     

    Files in this Management Pack

    The following table describes the files included in this Management Pack.

    File

    Display name

    Description

    Microsoft.SQLServer.Library.mp

    Microsoft SQL Server Core Library

    Contains the object types and groups that are common to SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012.

    Microsoft.SQLServer.Visualization.Library.mpb

    Microsoft SQL Server Visualization Library

    Contains basic visual components required for SQL Server dashboards.

    Microsoft.SQLServer.2008.Discovery.mp

    Microsoft SQL Server 2008 (Discovery)

    Contains definitions for object types and groups that are specific to SQL Server 2008 and SQL Server 2008 R2. It contains the discovery logic to detect all objects of the type defined on servers running SQL Server 2008 and SQL Server 2008 R2.

    Microsoft.SQLServer.2008.Monitoring.mp

    Microsoft SQL Server 2008 (Monitoring)

    Provides all monitoring for SQL Server 2008 and SQL Server 2008 R2.

    Note

    SQL Server 2008 and SQL Server 2008 R2 will not be monitored until you import this management pack.

    Microsoft.SQLServer.2008.Mirroring.Discovery.mp

    Microsoft SQL Server 2008 Mirroring (Discovery)

    Contains definitions for object types and groups that are specific to SQL Server 2008. It contains the discovery logic to detect all objects of the type defined on servers running SQL Server 2008 and SQL Server 2008 R2, which use Mirroring.

    Microsoft.SQLServer.2008.Mirroring.Monitoring.mp

    Microsoft SQL Server 2008 Mirroring (Monitoring)

    Provides all monitoring for Mirroring in SQL Server 2008 and SQL Server 2008 R2.

    Note

    Mirroring for SQL Server 2008 and SQL Server 2008 R2 will not be monitored until you import this management pack.

    Microsoft.SQLServer.2012.Discovery.mp

    Microsoft SQL Server 2012 (Discovery)

    Contains definitions for object types and groups that are specific to SQL Server 2012. It contains the discovery logic to detect all objects of the type defined on servers running SQL Server 2012.

    Microsoft.SQLServer.2012.Monitoring.mp

    Microsoft SQL Server 2012 (Monitoring)

    Provides all monitoring for SQL Server 2012.

    Note

    SQL Server 2012 will not be monitored until you import this management pack.

    Microsoft.SQLServer.2012.Mirroring.Discovery.mp

    Microsoft SQL Server 2012 Mirroring (Discovery)

    Contains definitions for object types and groups that are specific to SQL Server 2012. It contains the discovery logic to detect all objects of the type defined on servers running SQL Server 2012, which use Mirroring.

    Microsoft.SQLServer.2012.Mirroring.Monitoring.mp

    Microsoft SQL Server 2012 Mirroring (Monitoring)

    Provides all monitoring for Mirroring in SQL Server 2012.

    Note

    Mirroring for SQL Server 2008 and SQL Server 2008 R2 will not be monitored until you import this management pack.

    Microsoft.SQLServer.2012.AlwaysOn.Discovery.mp

    Microsoft SQL Server 2012 Always On (Discovery)

    Contains definitions for object types and groups that are specific to SQL Server 2012 Always On. It contains the discovery logic to detect all objects of the type defined on servers running SQL Server 2012 Always On.

    Microsoft.SQLServer.2012.AlwaysOn.Monitoring.mp

    Microsoft SQL Server 2012 Always On (Monitoring)

    Provides all monitoring for SQL Server 2012 Always On

    Note

    SQL Server 2012 Always On (Availability Groups, Availability Replicas and Database Replicas) will not be monitored until you import this management pack.

    Microsoft.SQLServer.2012.Presentation.mp

    Microsoft SQL Server 2012 Presentation

    SQL Server 2012 Presentation management pack. This management pack adds SQL Server 2012 Summary Dashboard.

    Microsoft.SQLServer.2008.Presentation.mp

    Microsoft SQL Server 2008 Presentation

    SQL Server 2008 Presentation management pack. This management pack adds SQL Server 2008 Summary Dashboard.

    Microsoft.SQLServer.Generic.Dashboards.mp

    Microsoft SQL Server Generic Dashboards

    Generic Dashboards Management Pack

    Microsoft.SQLServer.Generic.Presentation.mp

    Microsoft SQL Server Generic Presentation

    Generic Presentation management pack.

    The management pack also includes Microsoft Software License Terms, Datacenter Dashboard Guide and SQL Server Management Pack Guide.

     

    Other requirements

    To run the SQL Management Studio task and the SQL Profiler task, you must have SQL Server Management Studio and SQL Server Profiler installed on all Operations Manager computers where these tasks will be used.

    If you try to run one of these tasks without the appropriate features installed, you will receive “The system cannot find the file specified” error message.

    You do not need SQL Server Management Studio or SQL Server Profiler for discovery and monitoring.

     

    Security considerations

    As of the October 2009 release of SQL Server Management Pack package, agentless monitoring is no longer supported. This change was made to allow full support of monitoring for clustered resources.

    You may need to customize your management pack. Certain accounts cannot be run in a low-privilege environment or must have minimum permissions.

    The following topics are covered in this section:

    · Run As profiles

    · Low-privilege environments

    · Groups

    · TLS 1.2 protection

    Run As profiles

    When the SQL Server Core Library Management Pack is imported for the first time, it creates three new Run As profiles:

    · SQL Server Default Action Account

    · SQL Server Discovery Account

    This profile is associated with all discoveries.

    · SQL Server Monitoring Account

    This profile is associated with all monitors and tasks.

    By default, all discoveries, monitors, and tasks defined in SQL Server Management Packs use the accounts defined in the “Default Action Account” Run As profile. If the default action account for a given system does not have the necessary permissions to discover or monitor the instance of SQL Server, then those systems can be bound to more specific credentials in the SQL Server Run As profiles, which do have access.

     

     

    TLS 1.2 protection

    Operating protection of connections in SQL Server is provided by means of TLS protocol. In order to have the ability to use TLS 1.2 protocol, your environment should meet the following prerequisites:

    1. SQL Server should be updated to version that supports TLS 1.2.

    2. The following SQL Server drivers should be updated to version that supports TLS 1.2:

    · SQL Server Native Client <version>

    · ODBC Driver 11 for Microsoft SQL Server

    3. Make sure that your environment meets the prerequisites provided in the table below:

    OS Version

    SCOM Version

    .NET Version

    PowerShell version

    Windows 2012 and above

    Not less than minimal supported version**

    From 2.0 to 4.0 with TLS 1.2 update* and from 4.0 to 4.6 with TLS 1.2 update*

    3.0+

    Windows 2012 and above

    Not less than minimal supported version**

    From 2.0 to 4.0 with TLS 1.2 update* and 4.6+

    3.0+

    Windows 2008 R2 and below

    SCOM 2012 SP1 UR10 +

    SCOM 2012 R2 UR7 +

    From 2.0 to 4.0 with TLS 1.2 update* and 4.6+

    2.0+

    Windows 2008 R2 and below

    SCOM 2012 SP1 UR10 +

    SCOM 2012 R2 UR7 +

    From 2.0 to 4.0 with TLS 1.2 update* and from 4.0 to 4.6 with TLS 1.2 update*

    2.0+

    Windows 2008 R2 and below

    From minimal supported version** to SCOM 2012 SP1 UR9 or to SCOM 2012 R2 UR6

    From 2.0 to 4.0 with TLS1.2 update*

    2.0

    * .NET Framework TLS 1.2 updates can be downloaded from TLS 1.2 support for Microsoft SQL Server page (Client component downloads section).

    ** Minimal supported SCOM versions are stated in Supported Configurations section.

    Comments (0)

    Skip to main content