1.1.2 Collecting performance data based on its characteristics
PFM - Agent for Microsoft SQL Server collects performance data in records. Each record consists of smaller units called fields. Collectively, the records and fields are referred to as the data model.
Records are classified into two types according to their characteristics. These record types are predefined in PFM - Agent for Microsoft SQL Server. The user simply uses PFM - Web Console to specify the performance data records to be collected.
PFM - Agent for Microsoft SQL Server supports the following two record types:
-
Product Interval record type (referred to hereafter as the PI record type)
For records of the PI record type, the system collects performance data for a specified interval, such as the number of processes executed in one minute. You can use these records to analyze the changes or trends in the system status over time.
-
Product Detail record type (referred to hereafter as the PD record type)
For records of the PD record type, the system collects performance data that indicates the system status at a specific point in time, such as detailed information about the currently active processes. You can use these records to obtain the system status at a particular time.
For more information about record types, see 5. Records.