In SQLServer overview dashboard, under DTC (Distribution Transaction Coordinator) dashboard, could not see any data displayed. Observed "There is no data to dsiplay" messagein the chart. Observed a SQLServer alarm with the below error message
DBSS_DTC_Information Failed with the exception: The WMI execution of the script : [select AbortedTransactions,ActiveTransactions,CommittedTransactionsPersec,InDoubtTransactions,ResponseTimeAverage,TransactionsPersec from Win32_PerfFormattedData_MSDTC_DistributedTransactionCoordinator ] failed due to an invalid class error. You may need to refresh the Performance Counter Classes by executing the following command in the command prompt: "%windir%\system32\wbem\wmiadap.exe /f.".
Ran wbemtest.exe file and it failed in the server with "0x80041010 Invalid WMI class" error.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.