Resolution:
Description:
===========
Why TIBCO BusinessEvents application executes SQL "select count(*) from sysobjects;" every 30 seconds?

Environment:
===========
TIBCO BusinessEvents 3.x/4.n/5.n - Microsoft SQL server installation
All Operating Systems


Resolution:
=========
The SQL will be executed  to check if the database connection is still available. This should not cause any performance issues for the TIBCO BusinessEvents application.

NOTE:
You are able to connfigure the test SQL statement and the time interval for the connection tests with the following properties.

tibco.be.jdbc.test.connections.sql=&ltsql>
default SQL statement for SQL server: ' select count(*) from sysobjects'

# interval
tibco.be.jdbc.test.connections.interval (in seconds - default 60)

Why TIBCO BusinessEvents application executes SQL "select count(*) from sysobjects;" every 30 seconds?