SQL Server using wrong transaction isolation level
You're using MS SQL Server, and a banner is displayed at the bottom of the pages inside Fisheye containing this message:
Your database current transaction isolation level may lead to performance problems. Enable READ_COMMITTED_SNAPSHOT level.
The Fisheye database is not configured to use
READ_COMMITTED_SNAPSHOT transaction isolation level as recommended in the Migrating to SQL Server documentation.
- Stop Fisheye/Crucible
- Connect to the Fisheye database and run this SQL query:
ALTER DATABASE <db_name> SET READ_COMMITTED_SNAPSHOT ON;
<db_name> accordingly in the query above.
This query will wait until all active connections to the database are closed. Other active connections will block the query from running.
- Start Fisheye/Crucible