ALTER DATABASE rhq SET READ_COMMITTED_SNAPSHOT ON
RHQ currently does not support Microsoft SQL Server in production RHQ installations. This is to be considered an experimental feature still under development. If you would like to assist the RHQ team to complete the MS SQL feature, please contact us at the developer mailing list or at freenode in #rhq.
This feature has been developed against MS SQL Server 2005 and 2008. It will not work with any version earlier than 2005, but it may continue working with future versions.
It is assumed that you already have a MS SQL installation. Please see the MS SQL documentation for instructions on how to install it if you do not yet have it installed.
To use MS SQL with RHQ, you will need to perform some additional installation steps as described below.
Since MS SQL Server does not support MVCC, you must alter the database to use the "read committed with row versioning" MS SQL feature, which became available in MS SQL Server 2005. In order to use this MS SQL feature, you must execute the following SQL in your database (where "rhq" is the name of your database):
ALTER DATABASE rhq SET READ_COMMITTED_SNAPSHOT ON