User-Defined Counter Overview (PI_UCTR)
- Organization of this page
Function
The User-Defined Counter Overview (PI_UCTR) record indicates information related to each user-defined counter. Only one record is created.
Default and changeable values
|
Item |
Default value |
Changeable |
|---|---|---|
|
Collection Interval |
60 |
Y |
|
Collection Offset |
0 |
Y |
|
Log |
No |
Y |
|
LOGIF |
(Blank) |
Y |
|
Over 10 Sec Collection Time |
No |
N |
ODBC key field
None
Lifitime
From the time each counter is defined until the time the definition is canceled
Record size
-
Fixed part: 761 bytes
-
Variable part: 0 bytes
Fields
|
View name (Manager name) |
Description |
Summary |
Format |
Delta |
Data source |
|
|---|---|---|---|---|---|---|
|
Microsoft SQL Server version 2014 or earlier |
Microsoft SQL Server version 2016 or later |
|||||
|
Record Time (RECORD_TIME) |
Interval end time (GMT format) #1 |
COPY |
time_t |
No |
Agent Collector |
|
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always UCTR)#1 |
COPY |
char(8) |
No |
Agent Collector |
|
|
SQL User Counter 1 (COUNTER_1) |
Microsoft SQL Server user definition counter 1#1 |
COPY |
double |
No |
master..sysperfinfo.User counter1 |
sys.dm_os_performance_counters.User counter1 |
|
SQL User Counter 2 (COUNTER_2) |
Microsoft SQL Server user definition counter 2#1 |
COPY |
double |
No |
master..sysperfinfo.User counter2 |
sys.dm_os_performance_counters.User counter2 |
|
SQL User Counter 3 (COUNTER_3) |
Microsoft SQL Server user definition counter 3#1 |
COPY |
double |
No |
master..sysperfinfo.User counter3 |
sys.dm_os_performance_counters.User counter3 |
|
SQL User Counter 4 (COUNTER_4) |
Microsoft SQL Server user definition counter 4#1 |
COPY |
double |
No |
master..sysperfinfo.User counter4 |
sys.dm_os_performance_counters.User counter4 |
|
SQL User Counter 5 (COUNTER_5) |
Microsoft SQL Server user definition counter 5#1 |
COPY |
double |
No |
master..sysperfinfo.User counter5 |
sys.dm_os_performance_counters.User counter5 |
|
SQL User Counter 6 (COUNTER_6) |
Microsoft SQL Server user definition counter 6#1 |
COPY |
double |
No |
master..sysperfinfo.User counter6 |
sys.dm_os_performance_counters.User counter6 |
|
SQL User Counter 7 (COUNTER_7) |
Microsoft SQL Server user definition counter 7#1 |
COPY |
double |
No |
master..sysperfinfo.User counter7 |
sys.dm_os_performance_counters.User counter7 |
|
SQL User Counter 8 (COUNTER_8) |
Microsoft SQL Server user definition counter 8#1 |
COPY |
double |
No |
master..sysperfinfo.User counter8 |
sys.dm_os_performance_counters.User counter8 |
|
SQL User Counter 9 (COUNTER_9) |
Microsoft SQL Server user definition counter 9#1 |
COPY |
double |
No |
master..sysperfinfo.User counter9 |
sys.dm_os_performance_counters.User counter9 |
|
SQL User Counter 10 (COUNTER_10) |
Microsoft SQL Server user definition counter 10#1 |
COPY |
double |
No |
master..sysperfinfo.User counter10 |
sys.dm_os_performance_counters.User counter10 |
|
Start Time (START_TIME) |
Interval start time (GMT format) #1 |
COPY |
time_t |
No |
Agent Collector |
|