Hi,

I found the network transfert rate low between my 2 servers during cube
processes.
I have a 2Gbps network and only 2% is used during loading while I can go up
to 25% during "simple" file copy.

what are the performance counter to follow during the loading step of my
cube?
what can I do to improove this? there is any option anywhere? (in SQL or AS)

thanks for your guides.

Jerome.

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/pro.../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

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/pro.../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

all my cubes are allready optimized.

so, except for exceptions, the query used by AS is a simple select * from
facttable without any join.


<Myles.Matheson (AT) gmail (DOT) com> wrote