Our environment - Application Server: MS Windows 2003 SP 1 ARS 7.0.01, patch 001 ITSM 6 CMDB 1.1, patch 4
Database Server: MS Windows 2003 SP 2 MS SQL 2005 Our Remedy service suddenly began to run very sluggishly with users reporting long wait times to bring up or to update a case, or to login. This issue occurred for a couple of minutes (5 at most) before it cleared and users were able to access the system normally. A check of the SQL logs at about the time of the slowness revealed the following: <SQL > <TID: 0000000620> <RPC ID: 0001033776> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1530 */DROP TABLE AR0int620 <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1530 */OK <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1530 */UPDATE T28 SET C18255=NULL,C179='AG0019B9BBD70CSCWLTg9ArbDQr#cQ',C18254=5,C5='Remedy Application Service',C6=1317741937 WHERE C1 = '000000000508322' <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1530 */OK <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1530 */DELETE FROM T25 WHERE C1 = '000000008337604' <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1530 */OK <SQL > <TID: 0000000604> <RPC ID: 0001033777> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1530 */OK <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1530 */DELETE FROM H25 WHERE entryId = '000000008337604' <SQL > <TID: 0000000604> <RPC ID: 0001033777> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1530 */UPDATE T29 SET C18022 = 'placeholder' WHERE C1 = '000000003097234' <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1530 */OK <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1530 */COMMIT TRANSACTION <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1680 */OK <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1680 */SELECT T27.C1,T27.C1 FROM T27 WHERE (T27.C18032 = '000000018333725') ORDER BY 1 ASC <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1680 */OK <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1680 */BEGIN TRANSACTION <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1680 */OK <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1680 */DELETE FROM T31 WHERE C1 = '000000018333725' <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1680 */OK <SQL > <TID: 0000002504> <RPC ID: 0001033778> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1680 */DELETE FROM H31 WHERE entryId = '000000018333725' <SQL > <TID: 0000000620> <RPC ID: 0001033776> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1680 */*** ERROR *** Cannot drop the table 'AR0int620', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000000620> <RPC ID: 0001033776> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > /* Tue Oct 04 2011 11:25:37.1680 */DROP TABLE AR0float620 This message repeats with references to "drop table AR0float" or "drop table AR0char" or "drop table AR0decimal". I've never seen this before and wonder what does this refer to? Joe Kasell Navy Federal Credit Union _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"