Re: Using the READ_COMMITTED_SNAPSHOT database option on ARS Database

2011-12-22 Thread Jiri Pospisil
on if you go for this setting in production. Regards Jiri Pospisil LCH Clearnet From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd Sent: 20 December 2011 17:39 To: arslist@ARSLIST.ORG Subject: Using the READ_COMMITTED_SNAPSHOT database option

Using the READ_COMMITTED_SNAPSHOT database option on ARS Database

2011-12-20 Thread Arner, Todd
We are looking at enabling the READ_COMMITTED_SNAPSHOT database option to ON for AR System database per the recommendations in the Performance Tuning for Business Service Management white paper from BMC. I am curious if others are using this option and if it caused any issues after you enabled

Re: Using the READ_COMMITTED_SNAPSHOT database option on ARS Database

2011-12-20 Thread Joe Martin D'Souza
Server installed on the same physical /virtual machine as the Database server? Joe From: Arner, Todd Sent: Tuesday, December 20, 2011 12:39 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Using the READ_COMMITTED_SNAPSHOT database option on ARS Database ** We

Re: Using the READ_COMMITTED_SNAPSHOT database option on ARS Database

2011-12-20 Thread Arner, Todd
@ARSLIST.ORG Subject: Using the READ_COMMITTED_SNAPSHOT database option on ARS Database ** We are looking at enabling the READ_COMMITTED_SNAPSHOT database option to ON for AR System database per the recommendations in the Performance Tuning for Business Service Management white paper from BMC. I am