Page History
...
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. |
PW_SQJT_JOBS_STEPS_STATS_D
Holds information on the SQL Server instance job steps.
| 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 |
|---|---|
SQJT_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQJT_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 SQJT_PWHG_ID should be used. |
SQJT_PWHG_ID | Hour group ID. |
SQJT_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQJT_JOB_NAME | Name of the job. |
SQJT_JOB_ID | ID of the job, normalized in table PW_SQE3_ERP_IDENTIFIERS3_N. |
SQJT_STEP_ID | ID of the step, normalized in table PW_SQE4_ERP_IDENTIFIERS4_N. |
SQJT_DURATION_SUM | Total elapsed time. This counter is reported by the SQL Server and not by the Precise for SQL Server Collector agent. |
SQJT_EXECUTION_SUM | Total number of job executions. |
SQJT_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQJT_ROWID | Unique row number. |
PW_SQCJ_MTNC_CHANGE_JOB
Holds information on the SQL Server instance MTNC job changes.
| Column Name | Column Description |
|---|---|
SQCJ_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQCJ_JOB_NAME | Number of the job that was changed. |
SQCJ_ENABLED | Job status. |
SQCJ_START_STEP_NAME | Name of the first step that should run. |
SQCJ_CATEGORY_NAME | The job's category name. |
SQCJ_OWNER_NAME | The job's owner. |
SQCJ_EVENT_LOG_NOTIFY_LEVEL | When to write to log. |
SQCJ_EMAIL_NOTIFY_LEVEL | When to E-mail. |
SQCJ_NET_SEND_NOTIFY_LEVEL | When to send net. |
SQCJ_PAGE_NOTIFY_LEVEL | When to page. |
SQCJ_EMAIL_OPERATOR_NAME | To whom to send E-mail. |
SQCJ_NET_SEND_OPERATOR_NAME | To whom to send net. |
SQCJ_PAGE_OPERATOR_NAME | To whom to page. |
SQCJ_DELETE_LEVEL | When to do automatic delete. |
PW_SQCT_MTNC_CHANGE_STEP
Holds information on the SQL Server instance MTNC job step changes.
| Column Name | Column Description |
|---|---|
SQCT_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQCT_JOB_NAME | Number of the job that was changed. |
SQCT_STEP_NAME | Job step name. |
SQCT_SUB_SYSTEM_NAME | Name of the subsystem used by the SQL Server Agent to execute the job step. |
SQCT_COMMAND_TEXT | Command to be executed. |
SQCT_ON_SUCCESS_ACTION | Action to be performed when a step is executed successfully. |
SQCT_ON_SUCCESS_NEXT_STEP_NAME | The name of the next step to execute when a step name executed successfully. |
SQCT_ON_FAIL_ACTION | Action to be performed when a step is not executed successfully. |
SQCT_ON_FAIL_NEXT_STEP_NAME | The name of the next step to to execute when a step is not executed successfully. |
SQCT_DATABASE_NAME | Name of the database in which the command is executed. |
SQCT_DATABASE_USER_NAME | Name of the database user whose account will be used when executing the step. |
SQCT_RETRY_ATTEMPTS | Number of retry attempts made if the step fails. |
SQCT_RETRY_INTERVAL | Amount of time to wait between retry attempts. |