Re: Help with odd set of SQL operations by ARS

2018-06-19 Thread Charlie Lotridge
Great suggestion, thank you. That revealed the misbehaving mid-tier. Unfortunately I don't have access to the machine and my colleague, who set it up (as a test bed for something) is out of town, but I'm going to have him shut it down to resolve this issue. Thanks again! On Mon, Jun 18, 2018 at

Re: Help with odd set of SQL operations by ARS

2018-06-18 Thread LJ LongWing
It MIGHT be useful if we also had API loggingAPI logging would tell us definitively if it was Mid-Tier doing the call (which is what it looks like)...but it would also tell you the source IP of the machine making the callI have never seen this behavior before but I suspect it might be relat

Help with odd set of SQL operations by ARS

2018-06-18 Thread Charlie Lotridge
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* *