SQL SERVER - _TOTAL misconfigured

Last Modified

Thu Aug 02 06:14 GMT 2018

Description

  • Error: 102 Invalid class when process matrix 0 WQL = Select DataFilesSizeKB, LogFilesSizeKB, TransactionsPersec, Frequency_Sys100NS, ActiveTransactions, Timestamp_Sys100NS From Win32_PerfRawData_MSSQLServer_SQLServerDatabases Where Name="_Total"

Environment

  • N-able N-central

Solution

  1. Check if device has a Standard SQL Server version or Express (you can do it under Asset > Applications).
    If the version is Express, Microsoft does not support WMI classes for it, thus our service also does not work which is normal.
    If the version is Standard, check what instances that the SQL Server actually has by looking at Asset > Services > and sorting by Caption. Note the name of SQL Server instance
  2. If you check the Service Details tab of the service itself, you will see that you need to specify 3 correct WMI classes in order for the service to actually function properly.
  3. By default when you add service for the first time, it will be targeting default SQL Server instance.
  4. If you do not have a default instance, you will need to specify specific WMI classes based on the instance name:

If you have a named instance of SQL Server, then the name of the perf counter differs, e.g. for a named instance MSSQLSERVER the name is

Win32_PerfRawData_MSSQLSERVER_SQLServerDatabase
Make the changes under Service Details tab of the service.