topic Re: Transaction Isolation: Alfresco 2.1 MS SQL Server 2005 in Alfresco Archive

Transaction Isolation: Alfresco 2.1 MS SQL Server 2005

pbruna — Tue, 26 Oct 2010 18:42:24 GMT

I noticed that with Alfresco 3.1 i can configure the support for Transaction Isolation on MS SQL Server, with the parameter:db.txn.isolation=4096‍It's possible to use Transaction Isolation on Alfresco 2.1? I'm not MS SQL Server savy, just need to improve the stability for the next couple of weeks un

Re: Transaction Isolation: Alfresco 2.1 MS SQL Server 2005

mrogers — Fri, 29 Oct 2010 16:09:54 GMT

In general you can't fiddle with the isolation levels, the default values will have been set for a good reason.

While there may be odd use-cases, such is if you have a read only repo, or a write only repo, don't touch unless you are an
expert user, and you are doing something strange.