Skip to Content
0

Why is there so much sleep time in the threads and why are the threads not executing in parallel?

Mar 19 at 01:04 PM

43

avatar image
Former Member

We have a calculation view which has one projection consuming one Column table with 184 fields. When we do the Plan Viz we can see that the result fetch or the analytical search at the last node takes the maximum time. What we observed was the threads spawned were not running in parallel even when there was no other job running in the system and inside the thread themselves there was a lot of sleep time, between the fetches. I am attaching a link to the doc with all the details. Please can someone just suggest why a simple fetch is taking so much time. The system details are also there in the document.Doc present in google drive

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers