Skip to Content
0

Sleeping time in executed plan

Feb 13 at 10:07 PM

66

avatar image
Former Member

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?

10 |10000 characters needed characters left 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.

0
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

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers