Shulou(Shulou.com)06/01 Report--

22 、 Sys. Dm_tcp_listener_states

Returns a row that contains dynamic information for each TCP listener.

Remarks

The availability group listener may listen on the port on which the listener of the SQL Server instance listens. In this case, these listeners are listed separately, as in the case of Service Broker listeners.

Column name

Data type

Description

Listener_id

Int

The internal id of the listener. Cannot be null. Primary key.

Ip_address

Nvarchar (48)

The IP address of the listener that is online and currently listening. Both IPv4 and IPv6 addresses are allowed. If a listener has these two types of addresses, they are listed separately. The IPv4 wildcard is displayed as "0.0.0.0". The IPv6 wildcard is displayed as "::". Cannot be null.

Is_ipv4

Bit

Type of IP address

1 = IPv4

0 = IPv6

Port

Int

The port number on which the listener is listening. Cannot be null.

Type

Type_desc

Tinyint

Nvarchar (20)

Listener type, which can be one of the following values:

0 = TSQL Transact-SQL

1 = SERVICE_BROKER Service Broker

2 = DATABASE_MIRRORING database mirroring

Cannot be null.

State

State_desc

Tinyint

Nvarchar (16)

The status of the availability group listener, which can be one of the following values:

1 = ONLINE is online. The listener is listening for and processing requests.

2 = PENDING_RESTART waits for reboot. The listener is offline, waiting to restart.

If the availability group listener is listening on the port on which the server instance is listening, the two listeners always have the same state. Cannot be null.

Note: the values in this column come from the TSD_listener object. Column does not support offline status because it cannot query status when TDS_listener is offline.

Start_time

Datetime

Indicates the timestamp when the listener is started. Cannot be null.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.