x

PA doesn't collect data for multi-instances server

Performance Advisor stopped working on one windows server that hosts multiple SQL instances. And currently two of the SQL instances on that server are monitored by SQL sentry. PA worked before but suddenly stopped with the following errors. SQL Sentry account is the sysadmin on both Windows and SQL Server. Performance counter is also working on the Windows.

Errors: Task Faulted Error: An error has occurred: Message: Error reading performance category Process.

An error has occurred: Message: Error reading performance category Process.

System.Exception: Error reading performance category Process. ---> System.ArgumentException: An item with the same key has already been added. at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add) at Intercerve.SqlSentry.Server.ProcessInformationResolver.GetConnectionAccessorsByServiceName(List`1 eventSourceConnections) at Intercerve.SqlSentry.Server.ProcessInformationResolver.Refresh(List`1 eventSourceConnections, InstanceDataCollectionCollection performanceCategoryData) at Intercerve.SqlSentry.Server.DataCollectors.PerformanceAnalysisDataCollector.CollectCategory(String connectionStringName, PerformanceAnalysisConfigurationInformation performanceAnalysisConfigurationInformation, PerformanceAnalysisDataCollectorTask performanceAnalysisDataCollectorTask, PerformanceCounterCategoryEnumeratorItem performanceCounterCategoryEnumeratorItem, PerformanceAnalysisCounterResults counterResultSet, Dictionary`2 wellKnownProcessLookups, Boolean collectProcessInformation, CriteriaOperator criteriaOperator, Boolean criteriaHasChanged) --- End of inner exception stack trace --- at Intercerve.SqlSentry.Server.DataCollectors.PerformanceAnalysisDataCollector.CollectCategory(String connectionStringName, PerformanceAnalysisConfigurationInformation performanceAnalysisConfigurationInformation, PerformanceAnalysisDataCollectorTask performanceAnalysisDataCollectorTask, PerformanceCounterCategoryEnumeratorItem performanceCounterCategoryEnumeratorItem, PerformanceAnalysisCounterResults counterResultSet, Dictionary`2 wellKnownProcessLookups, Boolean collectProcessInformation, CriteriaOperator criteriaOperator, Boolean criteriaHasChanged) at Intercerve.SqlSentry.Server.DataCollectors.PerformanceAnalysisDataCollector.CollectPerformanceData(PerformanceAnalysisConfigurationInformation performanceAnalysisConfigurationInformation)

avatar image By l.li@wintoncapital.com 0 asked Dec 10, 2015 at 03:02 PM
more ▼
(comments are locked)
10|5000 characters needed characters left

1 answer: sort voted first

Hello, l.li.

It looks like you may be experiencing a problem with missing performance counters.

In most cases, a simple restart of the Remote Registry service on the target server and the SQL Sentry monitoring service will bring them back.

If the problem persists, however, the following steps will help you troubleshoot and/or rebuild the performance counters:

Make sure that you’re able to see the missing counters in Perfmon (check locally and remotely from the server hosting the SQL Sentry monitoring service)

If they’re not there, check the following path in the Registry (regedit.exe) for the “Disable Performance Counter” value:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance

  • If this value is present and is set to 1, change it to 0

  • Restart the Remote Registry service on the target server

  • Restart the SQL Sentry Monitoring service

If you are able to see and load the counters in Perfmon, a restart of the Remote Registry service may resolve the issue.

If it doesn't, the counters could be corrupted and you may need to rebuild them using the following steps:

  • Open cmd prompt (Run as Administrator)

  • Change path to the SQLSERVER Binn directory

  • Run “unlodctr MSSQLSERVER”

  • Run “lodctr perf-MSSQLSERVERsqlctr.ini” (if named instance, use the relevant .ini file from the Binn directory)

  • Restart the Remote Registry service

  • Restart the Performance Logs and Alerts service (if running)

  • Restart SQL Sentry Monitoring service

For reference, these steps can also be found in the following KB: http://answers.sqlsentry.com/questions/21/my-counters-are-not-working-how-can-i-fix-this.html.

Regards,

Jim

avatar image By James Holden ♦ 1.6k answered Dec 10, 2015 at 03:30 PM
more ▼
(comments are locked)
10|5000 characters needed characters left

This site is moving!

Our Q and A site has moved! Please visit our new Q and A site at support.sentryone.com to submit all new questions and to revisit our most-viewed and up-voted articles. For your convenience, this web page will be available in read-only mode for another two weeks.

Follow this question

Topics:

x29
x4

asked: Dec 10, 2015 at 03:02 PM

Seen: 128 times

Last Updated: Dec 10, 2015 at 03:39 PM

Related Questions