BT Sql Receive 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 receive adapter is a polling adapter that periodically polls for SQL result sets.

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

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 received

Indicates the total number of messages that are read by the SQL receive adapter from the SQL server.

Number

A high value could indicate an overload condition.

Messages received rate

Indicates the rate at which the messages are read by the SQL receive adapter from the SQL server.

Msgs/Sec

A consistent decrease in the value of this measure points you to current/potential bottlenecks in the processing of messages.