Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Server & Application Monitor (SAM) > AppInsight for SQL Performance Counter not found and restoration steps

AppInsight for SQL Performance Counter not found and restoration steps

Updated: 3-20-2017

Overview

You may encounter an issue with AppInsight for SQL Performance Counter not displaying in SAM. When viewing the AppInsight for SQL page and related resources, you may receive an error "Performance counter not found." For an example, see the following screenshot:

counters.JPG

 

Environment

  • All SAM versions
  • AppInsight for SQL

Resolution

Check for counters

To resolve, you first need to check for counters on the SQL database that is monitored by AppInsight for SQL (not the Orion SQL database). 

  1. Access the monitored SQL database that displays the error message.
  2. Run the following query to verify if counters are present:
SELECT
    RTRIM(object_name) as Category,
    RTRIM(counter_name) as [Counter],
    RTRIM(instance_name) as Instance,
    cntr_value as RawValue,
    cntr_type as CounterType
FROM sys.dm_os_performance_counters
ORDER BY CASE cntr_type WHEN 1073939712 THEN -1 ELSE cntr_type END

After running, you should see results like the following:

results.JPG

Results: If the query returns no values, you may have an issue with your SQL Server installation. You will need to contact Microsoft regarding this issue.

Use the Instance name column to find the name of the missing database and the counter it is associated with. If it does not exist for the counter, then the above errors are valid and you will need to work with your DBA / Microsoft to resolve the issue.

Remove Startup Parameter to attempt displaying counters

During the initial configuration of SQL Server, DBAs may disable the SQL Server Performance monitor counters to reduce SQL overheads. This is optional as certain diagnostics become unavailable, such as Parameter -x (see the screenshot below).

 

To access the SQL server properties screen, open the SQL Server Configuration Manager tool and look at the properties for that service.

:
 

Remove the Startup Parameter and Reboot the SQL Server.

Check to see if the Performance Counters are being created now by running the script in Check for counters.

 

Last modified
11:14, 30 Mar 2017

Tags

Classifications

Public