Difference in SQL performance counters from SQL mgmt pack between SQL standard vs Enterprise in Aria Operations SQL Management pack.

Products

• VMware Aria Suite

Issue/Introduction

 Unable to view the CPU usage in SQL metrics in Aria Operations for Microsoft SQL Server Standard database instances.

Environment

Aria Operations 8.18.X

Aria Operations Management pack for MicrosoftSQLServer 9.x

Resolution

This is a limitation of Microsoft SQL Server, and has no workaround.

As per Aria Operations Management pack for MicrosoftSQLServer 9.x System Requirements:

The CPU Usage metric for Microsoft SQL Server Instances is not available on MS SQL Server Standard or Express editions.