PDH SQL Interface Availability

Applies To: Windows Server 2008 R2

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