Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yavvie
Starting Member
46 Posts |
 Posted - 2009-08-06 : 03:39:11
|
| I need to find out how much data is transferred between our SQL database and report server. We need it to see if our internet connection will be enough when we move our SQL server to a different country and will have to transfer all data for the reports over the internet.Any ideas where I could find something like this?At the moment we have two servers on our network, one with SQL databases and the other with some frontend and ReportServer.I also need to find out which reports send the most data, how much data is sent when I just change a parameter, how much when I refresh the report.Any hints/ideas would be greatly appreciated.We are running both machines on windows server 2003, SQL 2008. |
|
|
yavvie
Starting Member
46 Posts |
Posted - 2009-08-07 : 02:33:06
|
| Solution:table ExecutionLog where the Reporting Server store the info - In particular TimeDataRetrieval, RowCount and ByteCountapplication like Network Monitor (used NetLimiter 2 Monitor) - data somewhat higher (about 40kB/report) which is the look and parameters of the report webpage |
 |
|
|
|
|
|
How to find amount of data transferred