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.