We get this message:

A query has been running longer than the 10 s threshold. A query
issued by connection 'Apply' (ID 2,916) has been running for 45 s. The
query is as follows:

null

Any ideas where we are getting null instead of the actual query?

v10.01.3629 database being monitored by v11.0.1.2324 client (on
separate machine from database server).

Thanks,
Brian

Hi Brian,

The most likely reason why you're not seeing the query text is that the
"RememberLastStatement" server option has been turned off. The SQL
Anywhere Monitor does turn this option on, but another application using
your database could have turned it back off again.

To test to see if RememberLastStatement is on, execute the following in
DBISQL:

SELECT PROPERTY ( 'RememberLastStatement' );

If it is turned off, you can turn it back on by executing the following:

CALL sa_server_option( 'RememberLastStatement','ON' );

Once you've turned it on, you should see the query text in your long
running query alerts.

Dan Petker
iAnywhere Tools Development

Brian wrote:

RememberLastStatement was indeed off. I have changed value and I
think this should resolve our issue.

Thanks,
Brian