When we execute 7 to 8 dashboard at a time , ( each dashboard has average 8 queries ), then each dashboard take too much time.
Data fedretor admin tool, shows only three queries running at time while all other queries status "waiting for execution".
some time queries run with system account user for long time continuously this also decrease dashboard performance
My BO system detail is given below
OS Windows 2008
RAM 64 GB
6 core IBM x3550
BO 4.0 SP6
please guide how we can increase dashboard performance and all queries run at a time with any delay.