Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Microsoft(R) SQL Server


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

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