Training
Module
Design a Performant Data Model in Azure SQL Database with Azure Data Studio - Training
Learn how to create a data model, tables, indexes, constraints, and use data types with Azure data studio.
SQL Log File Schema
Important
PDH support for ODBC SQL databases may be altered or unavailable in the future.
Applications can use PDH APIs read and write performance counter data in compatible ODBC SQL databases and then perform further processing through SQL queries. This section describes the SQL schema used to store performance counters. You can use this information to create custom views and reports. The schema consists of the following three tables:
Note
PDH support for ODBC SQL databases only works with ODBC SQL drivers that support Bulk Copy (BCP) Extensions.
Additional resources
Documentation
-
PerfRegInfoType (perflib.h) - Win32 apps
Indicates the types of information that you can request about a performance counter set by calling the PerfQueryCounterSetRegistrationInfo function.
-
Performance Counter Enumerations - Win32 apps
You use the following enumerations when working with performance data.
-
PerfCounterDataType (perflib.h) - Win32 apps
Indicates the content type of a PERF_COUNTER_HEADER block that the PerfQueryCounterData function includes as part of the PERF_DATA_HEADER block that the function produces as output.