TechNet
Export (0) Print
Expand All

Broker:Remote Message Ack Event Class

 

Applies To: SQL Server 2016

SQL Server generates a Broker:Remote Message Ack event when Service Broker sends or receives a message acknowledgement.

Data columnTypeDescriptionColumn numberFilterable
ApplicationNamenvarcharThe name of the client application that created the connection to an instance of SQL Server. This column is populated with the values that are passed by the application, instead of the displayed name of the program.10Yes
BigintData1bigintThe sequence number of the message that contains the acknowledgement.52No
BigintData2bigintThe sequence number of the message that is being acknowledged.53No
ClientProcessIDintThe ID assigned by the host computer to the process where the client application is running. This data column is populated if the client process ID is provided by the client.9Yes
DatabaseIDintThe ID of the database that is specified by the USE database statement. If no USE database statement has been issued for a given instance, the ID of the default database. SQL Server Profiler displays the name of the database if the ServerName data column is captured in the trace and the server is available. Determine the value for a database by using the DB_ID function.3Yes
EventClassintThe type of event class captured. Always 149 for Broker:Message Ack.27No
EventSequenceintSequence number for this event.51No
EventSubClassnvarcharThe type of event subclass, providing more information about each event class. This column can contain the following values:

 Message With Acknowledgement Sent:
                    Service Broker sent an acknowledgement as part of a normal sequenced message.

 Acknowledgement Sent:
                    Service Broker sent an acknowledgement outside a normal sequenced message.

 Message With Acknowledgement Received:
                  Service Broker received an acknowledgement as part of a normal sequenced message.

 Acknowledgement Received:
                  Service Broker received an acknowledgement outside a sequenced message.
21Yes
GUIDuniqueidentifierThe conversation ID of the dialog. This identifier is transmitted as part of the message, and is shared between both sides of the conversation.54No
HonorBrokerPriorityIntThe current value of the database HONOR_BROKER_PRIORITY option: 0 = OFF, 1 = ON.32Yes
HostNamenvarcharThe name of the computer on which the client is running. This data column is populated if the host name is provided by the client. To determine the host name, use the HOST_NAME function.8Yes
IntegerDataintThe fragment number of the message that contains the acknowledgement.25No
IntegerData2intThe fragment number of the message being acknowledged.55No
IsSystemintIndicates whether the event occurred on a system process or a user process.

0 = user

1 = system
60No
LoginSidimageThe security identification number (SID) of the logged-in user. Each SID is unique for each login in the server.41Yes
NTDomainNamenvarcharThe Windows domain to which the user belongs.7Yes
NTUserNamenvarcharThe name of the user that owns the connection that generated this event.6Yes
PriorityintThe priority level of the conversation.5Yes
RoleNamenvarcharThe role of the instance that is acknowledging the message. This is either initiator or target.38No
ServerNamenvarcharThe name of the instance of SQL Server that is being traced.26No
SPIDintThe server process ID assigned by SQL Server to the process that is associated with the client.12Yes
StartTimedatetimeThe time at which the event started, when available.14Yes
StarvationElevationintThe message was sent with a higher priority than the priority that was configured for the conversation: 0 = false, 1 = true.33Yes
TransactionIDbigintThe system-assigned ID of the transaction.4No

Community Additions

ADD
Show:
© 2016 Microsoft