Performance counter data not getting from PerfFormattedData (4341598)

Configured some performance counters monitor on SQL Server, but the returned value from "batchrequestspersec" (Win32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics\BatchRequestsPersec )  is very large, different from the actual data we check on the SQL Server host or from Windows perfMon. 

Agent will retrieve data from Win32_PerfRawData for Windows performance Counters, not from Win32_PerfFormattedData

Windows PerfMon is getting BatchRequestsPersec value from Win32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics and by design Foglight Agent will retrieve only from Win32_PerfRawData for Windows performance Counters.

To workaround:

1. Open Administration | Agents | Agent Status

2.  Select a specific agent\instance that you want to add the particular performance counter and click edit | Edit Properties

3. Click "Modify the private properties for this agent."

4. Go to "Performance Counter" and click edit

5. Click on Add row , in the "counter name" column put "Win32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics\BatchRequestsPersec" and in the "units" column choose "count"

6. click "Save Changes"

7. Deactivate and Activate the agent

You can now see the formatted data on performance counter page, because the formatted data change every second, if you want to see the updates more frequently, you need to go to Collections setting to change the relative frequency.