Page History
...
Holds information on grouping the changes, on which we track to groups. For example groups that contained schema changes and groups that contained instance/database definitions.
| Column Name | Column Description |
|---|---|
SQCG_GROUP_ID | ID of group1 for schema changes and of group 2 for instance/database definitions. |
SQCG_DATA_CHANGED | Name of the property that was changed. |
PW_SQPC_PERFORMANCE_COUNTERS
Maps SQL Server performance counter names to the Precise PMDB tables and columns.
| Column |
|---|
...
| Name | Column |
|---|
...
| Description | |
|---|---|
SQPC_OBJECT_NAME | Name of the performance Group as it appears in Microsoft SQL Server. |
SQPC_COUNTER_NAME | Name of the performance Counter as it appears in Microsoft SQL Server. |
SQPC_INSTANCE_NAME | Name of the performance Instance as it appears in Microsoft SQL Server. |
SQPC_TABLE_NAME | Name of the table in the Precise PMDB, which holds the value. |
SQPC_COLUMN_NAME | Name of the column in the Precise PMDB, which holds the value. |
SQPC_SCALE | The scale of the value, in case it shows with other statistics. |
SQPC_FROM_VERSION | Counter from |
...
| based on MS-SQL version. | |
SQPC_TILL_VERSION | Counter till |
...
| based on MS-SQL version. |
PW_SQNK_NETWORK_T
Holds information on network activities of the SQL Server instance.
| Column |
|---|
...
| Name | Column |
|---|
...
| Description | |
|---|---|
SQNK_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQNK_PWII_INSTANCE_NAME | Name of the network interface card. |
SQNK_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQNK_PWHG_ |
...
ID should be used. | |
SQNK_PWHG_ID | Hour group ID. |
SQNK_MINUTES_COUNT_SUM | The timeframe needed to calculated the row |
...
| , in minutes |
...
| . |
SQNK_OUTPUT_QUEUE_LENGTH |
...
_AVG | The average length of the output packet queue (in packets). If this is longer than 2, delays are being experienced and the bottleneck should be found and eliminated if possible. Because the requests are queued by NDIS in this implementation, this will always be 0. |
...
...
SQNK_OUTPUT_QUEUE_LENGTH |
...
_MAX | The maximum length of the output packet queue (in packets). If this is longer than 2, delays are being experienced and the bottleneck should be found and eliminated if possible. Because the requests are queued by NDIS in this implementation, this will always be 0. |
SQNK_PACKETS_SENT_AVG | The average rate at which packets are sent on the network interface. |
SQNK_PACKETS_SENT_MAX | The highest rate at which packets are sent on the network interface. |
SQNK_PACKETS_RECEIVED_AVG | The average rate at which packets are received on the network interface. |
SQNK_PACKETS_RECEIVED_MAX | The highest rate at which packets are received on the network interface. |
SQNK_BYTES_SENT_AVG | The average rate at which bytes are sent on the interface, including framing characters. |
SQNK_BYTES_SENT_MAX | The highest rate at which bytes are sent on the interface, including framing characters. |
SQNK_BYTES_RECEIVED_AVG | The average rate at which bytes are received on the interface, including framing characters. |
SQNK_BYTES_RECEIVED_MAX | The highest rate at which bytes are received on the interface, including framing characters. |
SQNK_ |
...
RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQNK_ROWID | Unique row number. |
PW_SQJS_JOBS_STATS_D
Holds information on the SQL Server instance jobs.
| Info |
|---|
...
The _D table summarizes the data per day. The _W table summarizes the data per week. The _M table summarizes the data per month. |
| Column |
|---|
...
| Name | Column |
|---|
...
| Description | |
|---|---|
SQJS_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQJS_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQJS_PWHG_ |
...
ID should be used. | |
SQJS_PWHG_ID | Hour group ID. |
SQJS_MINUTES_COUNT_SUM | The timeframe needed to calculated the row |
...
| , in minutes |
...
| . | |
SQJS_JOB_NAME | Name of the job. |
SQJS_JOB_ID | ID of the job, normalized in table PW_SQE3_ERP_IDENTIFIERS3_N. |
SQJS_DURATION_SUM | Total elapsed time. This counter is reported by the SQL Server and not by the |
...
| I4SQL collector. | |
SQJS_EXECUTION_SUM | Total number of job executions. |
SQJS_ |
...
RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQJS_ROWID | Unique row number. |