Are you trying to find the bytes sent/received from a particular query, or the amount of bandwidth being used for all queries under a given load?
If you want to get an idea of the bytes sent/received for a single query, just turn on "Include client statistics" under the Query menu in SQL Management studio.
If you want to see the network utilization under a load, the easiest way would be to generate a load from another machine and then use perfmon on the DB server and add the counters for the Network Interface's bytes sent/received to monitor the actual utilization.
If you are limited to one machine then you might be able to try something that can isolate a single processes network traffic, like netlimiter