Skip to Content
avatar image
Former Member

Sleeping time in executed plan

Hi,

I hope that somebody can help me with the issue we face:

I've a very simple calculation view (select some data from our COPA-table) without any joins. As the table does not have many records yet (about 1 million), I do not expect a very long processing time.

However, when I analyze the performance with "Visualize plan --> execute", it takes around a few minutes to execute it. Having a look at the result in the bar chart, I can see that most of the processing time is "Sleeping".

Does anybody have an idea why Hana has to sleep that much during execution of my calculation view?

Add comment
10|10000 characters needed characters exceeded

  • Can you provide some information about the HANA instance you're using? "sleeping" could be a sign of resource scarcity, e.g. no available threads to run on. A few minutes is definitively not correct behavior for a "very simple" calculation view.

  • Former Member

    Hi Lars,

    We are facing a similar issue with our HANA views as well. There are mainly two issues, threads are not running in parallel and there is lot of sleep time in the threads between fetches. I am attaching a word doc with the details. Ours is a cloud system with hosts one master and two worker, the system details are there too in the doc.Doc present in google drive

    Awaiting your reply.

    Best Regards

    Shilpi

  • Get RSS Feed

0 Answers