I am running ALTER DATABASE [JIRA-DATABASE] SET READ_COMMITTED_SNAPSHOT ON; command ? how long ?

IMSSPL March 26, 2019

I a m running 

ALTER DATABASE [JIRA-DATABASE] SET READ_COMMITTED_SNAPSHOT ON; - how long it will take?

1 answer

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 26, 2019

The speed of this is a function of your database hardware and the size of your data.  We can't tell you more than that.  I've seen big systems take hours and small ones take minutes.

Suggest an answer

Log in or Sign up to answer