Microsoft SQL Server Database dashboard Index Performance widget shows no data

Products

• VMware Aria Suite

Issue/Introduction

In Operations > Dashboards > Microsoft SQL Server Database > Index Performance, no data is shown. See image below:

Environment

Aria Operations 8.18.x

Microsoft SQL MP 9.1

Cause

On the collector node, there is a bug in the parsing of excluded_queries under /usr/lib/vmware-vcops/user/plugins/inbound/sql_server_adapter/conf/microsoftsqlserver.properties.

The following properties file parser we're using requires commas to be escaped:

collection_mode=include_index_queries
excluded_queries=Never Accessed Indexes Events,Index Performance,Unused Maintained Indexes,Highly Fragmented Indexes Events,Mildly Fragmented Indexes Events,Potentially Inefficient Indexes Events,Missing Beneficial Index Events

 

Resolution

Workaround:

1. SSH into the collector node as root user.

2. Go to /usr/lib/vmware-vcops/user/plugins/inbound/sql_server_adapter/conf/microsoftsqlserver.properties.

3. Locate the following entries:

collection_mode=include_index_queries
excluded_queries=Never Accessed Indexes Events,Index Performance,Unused Maintained Indexes,Highly Fragmented Indexes Events,Mildly Fragmented Indexes Events,Potentially Inefficient Indexes Events,Missing Beneficial Index Events

4. Edit and save the above excluded_queries to the following:

excluded_queries=Never Accessed Indexes Events\,Unused Maintained Indexes\,Highly Fragmented Indexes Events\,Mildly Fragmented Indexes Events\,Potentially Inefficient Indexes Events\,Missing Beneficial Index Events

5. The Index Performance widget should show data after the above change.