Skip to Content
0
Jun 14, 2011 at 02:48 PM

Poor Performance

41 Views

Hello All,

Currently i am facing some serious issue with Query performance.

Cube is having data accurate and latest data, but when i am executing query for even one day it is running for hours and hours and finally it is giving dump.

TSV_TNEW_PAGE_ALLOC_FAILED

I have also checked whther we can create any aggregate on cube, but there is no possibilty for creating aggregates as users are using data based on cal day.

I am confused that why suddenly we are query performance issue...

Regards,

Pankaj Naik