Hi Ravi - Can you please let me know the version of ARS and ITSM where you are facing this issue.. for one of our customer we are facing the same issue, there is one issue SRM form indexing that we have identified causing sql select queries to take longer time and was causing locks..
Is the CPU od DB spiking to 100%? We are still working on it and BMC has also suggeasted to use No Lock Parameter.. but customer is yet to implemente the same.. For more details on No Lock, please refer to Knowledge Article ID: KA314759. Hope this helps.. Regards, Bhupesh _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"