Does resusage report on data export volumes and how can we determine if there is a bottleneck?
We have many queries running at the same time exporting large amounts of data. The queires are being issued from a tool and are using ODBC ao TPT EXPORT is not an option. Is there a way using resusage data to measure export volume and determine if we are maxing out the export bandwith and if so where is the bottleneck occurring. If this can be proven, it will be easy to convince the customer to adjust the work load which may result in overall faster results.