Hi
Can anyone pleace help?
This is confussing me terribly!
Why does the DrillThrough performance get so bad:- 10 minutes and the
sqlserver is running at 100% CPU
I have 1Gb Memory, the memory is stable, no paging and a 2.0ghrtz CPU
It returns 5 lines
If i remove the Page Filters and have no where clauses the command runs in
5 - 6 seconds
What is going on????
Please help
Thanks

Hi,

Looks to me if we need some performance and tuning, a few suggestions:

-Trying to improve performance by adding indexes on the fields
corresponding to the levels for which the drillthrough filters on (also PK
and FK constraints, and indexes on the FK's).
-optimised the cube
-you may need to give your member keys unique), see also:
http://www.microsoft.com/technet/tre...hNet/ProdTechn
ol/SQL/Maintain/Optimize/ANSvcsPG.asp
-If you still got problems I suggest you use SQL Trace to view the SQL
statements generated and perhaps pass them through the SQL Indexing wizard.

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."

Hi Bas
I appreciate the response, thanks for the advice
The big problem is sitting on a Time Dimension field
When I drillthru at the top level it is very quick, as I go down to the day,
it slows down tremendously
Thanks
""Bas Kersten [MSFT]"" <bask (AT) online (DOT) microsoft.com> wrote