Resolution:
Description:
===========
TIBCO BusinessEvents applicaiton slow - some database deadlocks (Microsoft SQL server database only).

Environment:
===========
TIBCO BusinessEvents 4.n/5.n - Microsoft SQL Server 2008 and later
All Operating Systems

Symptoms:
=========
- TIBCO BusinessEvents application processing is slow
- Deadlocks on database

Cause:
======
Microsoft SQL Server configuration

Resolution:
=========
Update database settings (see also: http://msdn.microsoft.com/en-us/library/tcbchxcb(v=VS.80).aspx )

ALTER DATABASE &ltMyDatabase> SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE &ltMyDatabase> SET READ_COMMITTED_SNAPSHOT ON