Share via

PDH SQL Interface Availability

  • Article

Applies To: Windows Server 2008

Performance Data Helper (PDH) provides an interface for viewing and selecting available performance counters on a system. By default, it utilizes an internal SQL database to store and read counter data. By accessing the SQL database, Performance Data Helper bypasses reading and writing registry and system values. If the SQL interface is unavailable, Performance Data Helper cannot respond to queries for performance counter values.

Events

Event ID Source Message

0

Microsoft-Windows-PDH

 The returned data is valid.

1

Microsoft-Windows-PDH

 The returned data value is valid and different from the last sample.

3040

Microsoft-Windows-PDH

 Call to SQLAllocStmt failed with %1.

3041

Microsoft-Windows-PDH

 Call to SQLAllocConnect failed with %1.

3042

Microsoft-Windows-PDH

 Call to SQLExecDirect failed with %1.

3043

Microsoft-Windows-PDH

 Call to SQLFetch failed with %1.

3044

Microsoft-Windows-PDH

 Call to SQLRowCount failed with %1.

3045

Microsoft-Windows-PDH

 Call to SQLMoreResults failed with %1.

3046

Microsoft-Windows-PDH

 Call to SQLConnect failed with %1.

3047

Microsoft-Windows-PDH

 Call to SQLBindCol failed with %1.

3061

Microsoft-Windows-PDH

 SQL log format is not correct. Correct format is "SQL:<DSN-name>!<LogSet-Name>".

3069

Microsoft-Windows-PDH

 Cannot alter CounterDetail table layout in SQL database.

Performance Subsystem

Management Infrastructure