Is there some table in MS SQL 2005 that tracks how much data has been imported or bytes sent and received? So I can try and monitor this or check how this is going?
The simplest way to do this is the query the management views associated with the currently-executing request, the session, or the connection:
The first two expose a
row_count attribute that contains the number of rows returned by the query so far. If you know the total number of rows that will be returned (even roughly) this can provide a simple progress indication.
The third view provides
num_writes indicating how many network packets have been sent and received by the connection. The size of the network packet in use for that connection is given in the
net_packet_size attribute. The reads and writes include protocol overhead, and are not reset to zero at the start of each query or statement, so you would need to record the values before the query of interest starts executing.
All three views allow you to specify the
session_id you are interested in, for example:
FROM sys.dm_exec_requests AS DER
WHERE session_id = 52;