BT SQL Send Adapter Test

The SQL adapter exchanges data between the BizTalk Server and a SQL Server database. You can use the SQL adapter to poll data from one or more data tables and transmit the data as one or more XML messages to BizTalk Server. You can also use the SQL adapter to move large amounts of data to or from the SQL Server database as part of a BizTalk Server messaging or orchestration solution. In addition, you can use the SQL adapter to insert, update, and delete data in SQL Server tables by using SQL updategrams or by invoking stored procedures. The SQL adapter consists of two adapters - a receive adapter and a send adapter.

The SQL send adapter is used to send dynamically created updategrams or dynamically invoked stored procedures to SQL Server. An updategram is an XML fragment that inserts, updates, or deletes data in a SQL Server database by mapping XML nodes against database tables and columns. SQL Server returns an optional response document after the updategram completes, which contains the success status of the update. If a failure occurs during the update, the SQL adapter throws an exception that the BizTalk Messaging Engine handles. When the SQL send adapter is configured to invoke a stored procedure, it returns any results in the form of a single XML-formatted record set.

This test monitors the load on the SQL Send Adapter and proactively alerts you to potential overload conditions and processing bottlenecks.

Target of the test : A BizTalk Server 2010

Agent deploying the test : An internal agent

Outputs of the test : One set of results for each host instance on the BizTalk server being monitored

Configurable parameters for the test

Parameters	Description
Test period	This indicates how often should the test be executed.
Host	The host for which this test is to be configured.
Port	The port at which the host listens to.
Ispassive	If this parameter is set to Yes, then it means that, by default, all BizTalk servers being monitored by the eG system are the passive servers of a BizTalk cluster. No alerts will be generated if the servers are not running. Measures will be reported as "Not applicable" by the agent if the servers are not up.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
Messages sent	Indicates the total number of messages that are sent by the SQL send adapter to the destination SQL table in the SQL server database.	Number
Messages sent rate	Indicates the rate at which the messages are sent by the SQL send adapter to the destination SQL table in the SQL server database.	Msgs/Sec	A consistent decrease in the value of this measure points you to current/potential bottlenecks in the processing of messages.