Improving HTTP access for slow connections? (SSAS2005)

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

I want to know what are the best configuration option in both the client
connection string & server config to improve the speed for my users?

they are connected through a slow connection and they use Excel.
So the pivottable.

the initial connection is the slowest part because the system transfert the
cube metadata which is big (100 dimensions,attribute & measures to load)

The compression level is set to 9
the packet size to 32000
protection level = connect

When I monitor the network traffic 60% of the traffic go from the server to
the client and 40% from the client to the server!!!!
So why there is a so big upload traffic? can I reduce it?
which parameter can I change on the server side?
there is any option in the msmdpump.ini file to optimize this?

the initial connection takes 2minutes!!!
after the initial connection, the performance is good.

also the bandwidth is not used at 100%.
If I download something from the server (using an HTTP or FTP access) I can
download 2 time faster and I'm at the maximum speed available.
So I should be able to double the speed for my XMLA access and then reach
100% of the bandwidth. (how?)

thanks for your help and guides.

Jerome.


.

Relevant Pages

  • Re: .Net Scalability problem
    ... LoadRunner will peak out a server with a few virtual users. ... To get an idea of load, ... Fire off the test client and watch the number of ... > So I think that the MTC generate concurrent connection and per ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection lost at same time every hour (sometimes)
    ... After making the two following alterations on the server the problem seems ... After analyze your ipconfig on SBS and client, ... Then, other connection is good, ...
    (microsoft.public.windows.server.sbs)
  • Re: server disconnection - very often
    ... Reason of permanent popups is VMware server aplication on clients. ... Run CEICW to configure the network of SBS: ... Two network adapters - manual router connection to broadband ... Uninstall VMware on client. ...
    (microsoft.public.windows.server.sbs)
  • Re: Lan setup 2 nic
    ... The external nic only has TCP/IP enabled. ... Ipconfig of the server is looking good, but the client is still missing the ... > connection so we have a 2 nic with router setup now. ...
    (microsoft.public.windows.server.sbs)
  • Re: Regular disconnections from remote web workplace
    ... I can connect to office server and all office clients from home at all times ... be physically working right up until the connection is lost. ... If I enter http://companyip from a client I receive the login screen for the ... Click Services tab and select Hide All Microsoft Services and Disable ...
    (microsoft.public.windows.server.sbs)