Try OpenEdge Now
skip to main content
Configuration
Configuring DataServers : MS SQL Server DataServer configuration and administration : Viewing the status of an MS SQL Server DataServer broker : MS SQL Server DataServer broker property status summary and details
 
MS SQL Server DataServer broker property status summary and details
Table 44. MS SQL Server DataServer broker property status summary
Property
Description
Host
The broker's host machine.
Broker Name
The name of the broker whose status you are viewing.
Operating Mode
For DataServer brokers, the operating mode is state-aware.
Broker Status
The current state of the broker.
Broker Port
The TCP/IP port number that the broker listens to.
Broker PID
The process ID of the broker.
Active Servers
The number of active servers.
Busy Servers
N/A
Locked Servers
N/A
Available Servers
N/A
Active Clients (now, peak)
N/A
Client Queue Depth (cur, max)
The number of clients waiting for agents to become available to service their request. The current value (cur) represents the number of waiting clients at the moment the status is displayed, and the maximum value (max) represents the largest number of clients waiting concurrently since the broker was started.
Total Requests
N/A
Rq Wait (max, avg)
N/A
Rq Duration (max, avg)
N/A
Table 45. MS SQL Server DataServer broker status details
Property
Description
PID
The process id of the server process
State
The current state of the server process
Port
The TCP/IP port number used by the server
nRq
N/A
nRcvd
N/A
nSent
N/A
Started
The time stamp indicating when the server process is started
Last Change
The time stamp indicating when the server process last changed state