We have a canned product (JIRA) and we recently migrated the database from sql 2008 to 2014. We are now encountering a few deadlocks daily on the database. Now JIRA's Solution was the folowing:
First, please ensure the database is set to READ_COMMITTED_SNAPSHOT ON as per Connecting JIRA to SQL Server.
I'm not familiar with this setting and was wondering what it will do and are there any adverse effects?