[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

Help with odd set of SQL operations by ARS



Hi,

I'm not exactly sure when this started, but within the past few weeks my production ARS has started repeatedly issuing the following three SQL statements:

SELECT  TOP 2  T127.C1,C124 FROM T127 WHERE (T127.C101 = N'MidTier Service') ORDER BY 1 ASC
SELECT MAX(timestamp) FROM user_cache
SELECT MAX(timestamp) FROM group_cache

T127 is the User form.

It's doing this about 10 times per second.

Can anyone shed any light on what it's doing and how I can stop it? Any help would be appreciated.

Here is the raw SQL logging should the additional detail be useful:

<SQL > <TID: 0000007056> <RPC ID: 0003449550> <Queue: List      > <Client-RPC: 390620   > <USER: MidTier Service-- Impersonated by MidTier Service --> <Overlay-Group: 1         > /* Mon Jun 18 2018 07:34:34.8220 */SELECT  TOP 2  T127.C1,C124 FROM T127 WHERE (T127.C101 = N'MidTier Service') ORDER BY 1 ASC
<SQL > <TID: 0000007056> <RPC ID: 0003449550> <Queue: List      > <Client-RPC: 390620   > <USER: MidTier Service-- Impersonated by MidTier Service --> <Overlay-Group: 1         > /* Mon Jun 18 2018 07:34:34.8230 */OK
<SQL > <TID: 0000006596> <RPC ID: 0003449552> <Queue: Fast      > <Client-RPC: 390620   > <USER: MidTier Service                              > <Overlay-Group: 1         > /* Mon Jun 18 2018 07:34:34.8570 */SELECT MAX(timestamp) FROM user_cache
<SQL > <TID: 0000006596> <RPC ID: 0003449552> <Queue: Fast      > <Client-RPC: 390620   > <USER: MidTier Service                              > <Overlay-Group: 1         > /* Mon Jun 18 2018 07:34:34.8580 */OK
<SQL > <TID: 0000006596> <RPC ID: 0003449552> <Queue: Fast      > <Client-RPC: 390620   > <USER: MidTier Service                              > <Overlay-Group: 1         > /* Mon Jun 18 2018 07:34:34.8580 */SELECT MAX(timestamp) FROM group_cache
<SQL > <TID: 0000006596> <RPC ID: 0003449552> <Queue: Fast      > <Client-RPC: 390620   > <USER: MidTier Service                              > <Overlay-Group: 1         > /* Mon Jun 18 2018 07:34:34.8580 */OK

Thanks,
Charlie