Management Pack for Microsoft SQL Server

The Blue Medora VMware vRealize Operations Management Pack for Microsoft SQL Server is an embedded adapter for vRealize Operations (vROps), collecting performance data from your Microsoft SQL Server environment and providing predictive analytics and real-time information about problems in your infrastructure—all within the vRealize Operations user interface.

Notable Features

The Management Pack for Microsoft SQL Server includes the following notable features:

  • 7 comprehensive monitoring dashboards, including:
    • Microsoft SQL Server DBA Overview – Get a bird's-eye view into the overall health and performance of your SQL Server instance
    • Microsoft SQL Server Database – Drill down into the performance details of your SQL databases, including index performance, database size break-down, disk capacity, status, and alerts
    • Microsoft SQL Server Query Plan – Generate query plans to help troubleshoot slow queries
    • Microsoft SQL Server VM Relationship – Gain visibility into the relationship between your virtual hosts and SQL Server instances, with the ability to view KPIs side-by-side
  • 250+ collected metrics for Microsoft SQL Server resources

  • 30+ detailed alerts and notifications for critical and warning conditions

  • Capacity definitions for connection limit, CPU demand, memory usage, and disk capacity

  • External relationships from your VMware Virtual Machines to SQL Server Instance and Always On Availability Groups

Getting Started

Wondering where to start? See our Getting Started (Microsoft SQL Server) and System Requirements (Microsoft SQL Server) topics for details.

Release Notes

VersionRelease DateDescription 23, 2019Updated to support vRealize Operations 7.x and 8.x (does not support vRealize Operations 6.x) 23, 2019 This release adds jobs and steps, as well as alerts for job status. 12, 2019 

This release incorporates a number of bug fixes and optimizations, including:

  • Achieved better performance and reliability by using simple token auth
  • Added support for hostnames with underscores
  • The instance resource is no longer stripped from the collection result
  • The Query plan dashboard and action will now use the query plan cache to find and display the appropriate query plan 18, 2018

Performance fine-tuning release, including:

  • Added 2 new properties file settings: collection_mode and excluded_queries (See: Configuring the Properties File (Microsoft SQL Server))
  • Deprecated one metric: Unallocated space available (Database)
  • Refined least-privileged user (LPU) requirements (See: Assigning MS SQL User Privileges)
  • Clarified Availability Group configuration (See: Creating an Adapter Instance (Microsoft SQL Server))
  • Rolled in the following LA release: Fixed an issue where relationships between SQL Server instances and VMware VMs were not being created via MAC address (optionally through vSphere) and host name. This fix will also attempt to make the relationship via the Current Cluster Owner metric, allowing more customers to see relationships between their cluster and the VM it is running on. 30, 2018
  • Added support for Microsoft SQL Server 2017
  • Added 2 new dashboards: Microsoft SQL Server Query Plan and Microsoft SQL Server DBA Overview
  • Deprecated 6 dashboards: Availability Group Overview, Environment Overview, Info, Top-N Database, Top-N SQL Server, and Virtualization Disk
  • Added 16 new alerts for critical and warning conditions (See: Alerts (Microsoft SQL Server))
  • Added 2 new Advanced Configuration Settings: Exclude All Events and Exclude Only Log-Based Events (See: Creating an Adapter Instance (Microsoft SQL Server))
  • Created an optional automated adapter instance creation vRealize Orchestrator workflow
  • Fixed a bug where collection of CPU Usage for SQL Server Instances did not occur (Note existing limitation for SQL Server Standard and Expressversions)
  • Refined Least-Privileged User requirements and added script
  • Added support for database names that use spaces, dollar signs ( $ ), and dashes ( - ) (Note existing limitation for single quotes ( ' )) 12, 2018
6.2.10200014March 15, 2017
  • Incorporates the following bug fixes from previous limited availability releases:
    • An issue with cross-domain AD authentication failures
    • An issue when deploying to a remote collector
    • An issue where duplicate objects were created for the same AO Availability Groups
6.2.10200011December 9, 2016
  • Added support for vROps 6.2+
  • Added support for Microsoft SQL Server 2016
  • Added Query resource kind
  • Added Microsoft SQL Server Query Analysis dashboard
  • Improved event performance
  • Removed actions
6.0.10100032September 30, 2016
  • Added support for True Visibility Suite licensing
  • Fixed string metrics
  • Fix for multiple VMs with same hostname/IP
  • Added six metrics:
    • SQLServer
      • creation date
      • time since creation
      • last started date
      • time since last started
    • SQLDatabase
      • creation date
      • time since creation
  • Added “Memory” metric group to database with 3 metrics:
    • db_buffer_pages
    • db_buffer_mb
    • effective_buffer
  • Added “Database Memory Capacity” container
  • Added SqlDatabase as a consumer of SqlServer memory
  • Select statements for queries and cpu work with named SQL Server instances
6.0.10100024October 27, 2015
  • Support for 6.1 and accumulating licenses
  • Updated EULA for Blue Medora Inc.
6.0.10100018July 3, 2015Initial General Availability release for vRealize Operations 6.0

Known Issues/Limitations

  • Currently the Management Pack does not support indexing metrics out of the box. In order to enable this, please see Configuring the Properties File (Microsoft SQL Server).
  • The Retrieve Query Plan action (see: Generating a Query Plan) will fail for queries containing a scalar variable.
  • Database names containing single quotes ( ' ) are not supported.
  • The CPU Usage metric for Microsoft SQL Server Instances is not available on Microsoft SQL Server Standard or Express editions.

See also:

System Requirements (Microsoft SQL Server)