Hi,

Can anybody point me in the direction (case studies, whitepapers etc...) of
how to measure the amount of data that is transferred accross the network in
a user query, and for a query session? We will be using Pivot tables as a
front end and want to measure the impact for sites that have a small amount
of bandwidth.

Cheers

Hi,

Have a look at:

The performance guide:
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
#XSLTsection127121120120

Operation guid
http://www.microsoft.com/technet/pro.../anservog.mspx

Keep in mind that you can remote the query to the server by adding
Execution Location=3;Default Isolation Mode=1 into the connection string.
That will save you some network traffic.

HTH,
Bas


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