on 2022 Mar 16 8:48 AM
While using SQL Anywhere 17.0.10.6175 and 17.0.11.6800 I encounter an error on a production server that connection property LastReqTime is earlier by 5 to 15 minutes. In some cases LastReqTime is even earlier than LoginTime.
select * from sa_performance_diagnostics() where LastReqTime < LoginTime
How can this be? I can not reproduce it on any of my dev environments, and have no idea where to start to search for a fix.
Update 1:
select @@version, current time, connection_property('LastReqTime')
User | Count |
---|---|
72 | |
11 | |
10 | |
7 | |
7 | |
7 | |
7 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.