John, "ALLOW_SNAPSHOT_ISOLATION" & "READ_COMMITTED_SNAPSHOT" settings are required to enable "Row versioning framework in SQL Server" to avoid deadlock due to concurrent update of data in same table. Database deadlock is experienced during ITSM Install/Upgrade when multithreaded data-import is done. tempdb size plays important role in "Row versioning" hence its setting are also mentioned in BMC's document.
For more information on Row versioning, please check following link. <http://msdn.microsoft.com/en-us/library/ms189050(v=sql.105).aspx> regards Ranjit _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
