I could comment on the drop table issue, but I think Misi or someone will probably be able to do so more intelligently than I, and I don't think that is causing your problem anyway. The thing that jumped out at me was your Entry IDs, which were in seven or eight non-zero digits (3 million+/18 million+). How many records do you still have in those tables? At high row counts, deleting a record, as was tracked in the /DELETE FROM H25 WHERE entryId = '000000008337604' or DELETE FROM H31 WHERE entryId = '000000018333725' statements, is something that causes the indexes on those forms to be re-shuffled. That can take some time, especially if you have very high row counts.
Rick On Tue, Oct 4, 2011 at 9:55 AM, Joseph Kasell <joseph_kas...@navyfederal.org > wrote: > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
