select now() from sys.dummy

[candy_zhan]

Hi,

Does anyone know anything about below sql in HANA?

>  select now() from sys.dummy

Thanks~

[Former Member · Accepted solution]

Candy,

As mentioned by Krishna, this query should not lead to index server crash as it is fairly a simple one.

Please look at complete log trace to identify issue for index server crash, in case you still find the same issue i will suggest to raise support message to SAP.

Kulwinder

[former_member182302]

What is your question here? the query you have framed will give the current timestamp.

Regards,

Krishna Tangudu

[candy_zhan]

Hi Krishna,

I can see the query is occupying a lot of resouces,  inexserver crash, high CPU, OOM.

Do you have any idea about it?

Thanks,

Candy

[former_member182302]

Are you using this query to show the current time/screen refresh time in the dashboard? Never came across the issues relating occupying many resources for this query.

It is supposed to be a simple query on the row table dummy to get the current timestamp.

Regards,

Krishna Tangudu