The following error occurs in Spotlight when monitoring a SQL Server instance:
"SQL Server performance counters are not available"
Spotlight relies on SQL Server performance counters to gather monitoring data. Refer to below Microsoft article on how to resolve SQL Server performance counters:
https://blogs.technet.microsoft.com/pfelatam/2011/08/08/sql-performance-counters-are-missing/
Reboot server.