<Myles.Matheson@gmail.com> wrote in message
news:1118726390.628845.253400@g43g2000cwa.googlegroups.com...
> Hello J,
>
> I am not 100% sure what you need to look at as it could be many
> factors. I would look at SQL server first. Check what the query
> response time is. Using SQL profiler I would check that query is using
> the appropriate indexes and so forth.
>
> Once the Queries are optimised, have a look at this link as it has
> heaps of suggestions for managing Analysis services Servers including
> what to look for when considering performance.
>
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
>
>
> Also check out http://www.sql-server-performance.com/ For Analysis
> services and SQL server tuning tips.
>
> Hope this helps
>
>
> Myles Matheson
> Data Warehouse Architect
>