In Operations > Dashboards > Microsoft SQL Server Database > Index Performance, no data is shown. See image below:
Aria Operations 8.18.x
Microsoft SQL MP 9.1
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
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.