Licensing Detail (PD_LIC)
- Organization of this page
Function
The Licensing Detail (PD_LIC) record indicates licensing information, such as the maximum number of Microsoft SQL Server connections allowed. 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
Lifetime
From the time a Microsoft SQL Server instance is created until the time it is deleted
Record size
-
Fixed part: 689 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) |
-- |
time_t |
No |
Agent Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always LIC) |
-- |
char(8) |
No |
Agent Collector |
|
Session Count (CLIENT_COUNT) |
Number of sessions connected to the Microsoft SQL Server during data collection |
-- |
ulong |
No |
master..sysperfinfo |
sys.dm_os_performance_counters |
Session Limit (CLIENT_LIMIT) |
Maximum number of sessions allowed to connect to the Microsoft SQL Server |
-- |
ulong |
No |
@@max_connections |
|
Start Time (START_TIME) |
Interval start time (GMT format) |
-- |
time_t |
No |
Agent Collector |