Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Server & Application Monitor (SAM) > AppInsight for SQL Performance Counter Not Found

AppInsight for SQL Performance Counter Not Found

Updated: 9-28-2017

Overview

If AppInsight for SQL cannot find a performance counter on a monitored system, an error message may appear in SAM logs, or the AppInsight for SQL page and related resources may display "Performance counter not found" errors as shown in the following code example and screenshot.   

 

WARN SolarWinds.APM.Probes.PerformanceCounters.MultiCounterHelper - Counter failed. Target:127.0.0.1, Instance:, Category:Memory, Counter:Pages/Sec, ErrorCode:Unhandled, OSError:0x80131500. Message: Unable to collect WMI mapping information for given category value: Memory and counter: Pages/Sec for target: 127.0.0.1

 

counters.JPG

 

Environment

  • All SAM versions
  • AppInsight for SQL

Resolution

Check for counters

To resolve this issue, start by checking 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 this query to verify if counters exist in the database:
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

Query results should resemble this example:

 

results.JPG

 

If the query returns no values, the issue may be related to your SQL Server installation. Contact Microsoft Support.

 

Try using the Instance name column to find the name of the missing database and its associated counter. If no databases exist for the counter, then the errors described above are valid and you'll need to work with your DBA and/or Microsoft to resolve the issue.

Remove Startup Parameter to allow script to  create performance counters

During the initial configuration of SQL Server for the SQL database monitored by AppInsight for SQL, performance counters may have been disabled to reduce SQL overhead. If so, some diagnostics such as parameter "-x" will not be available, as shown in the next screenshot. 

 

Try using SQL Server Configuration Manager to remove Startup Parameters so the script included in the Check for counters section can create performance counters. 

 

  1. Open SQL Server Configuration Manager for the SQL database that is monitored by AppInsight for SQL (not the Orion SQL database).
  2. In SQL Server Configuration Manager, click SQL Server Services.
  3. In the details pane, right-click SQL Server (<instancename>), and then click Properties.

  4. Switch to the Startup Parameters tab and examine properties for that service.

 

:
 

  1. Remove the Startup Parameter.
  2. Reboot the SQL Server.
  3. Run the script in the Check for counters section.
  4. Check to see if performance counters were created.

 

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any. Screenshots property of © 2017 Microsoft.

 

Last modified

Tags

Classifications

Public