SQL Server using wrong transaction isolation level

Still need help?

The Atlassian Community is here for you.

Ask the community

Problem

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.

Cause

The Fisheye database is not configured to use READ_COMMITTED_SNAPSHOT transaction isolation level as recommended in the Migrating to SQL Server documentation.

Resolution

  • Stop Fisheye/Crucible
  • Connect to the Fisheye database and run this SQL query:
ALTER DATABASE <db_name> SET READ_COMMITTED_SNAPSHOT ON;

Please change <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

Last modified on Nov 2, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.