What is the highest throughput possible? Has anyone seen anything above 25MB/sec?
I've been trying to figure out what is even possible.
I know there are tuning parameters like packet size, and rows per batch and so one, plus there is overhead involved if going over TCP. I can copy a file at sustained 250MB/sec. I haven't found any way to pull > 16MB/sec or so through a query.
I got bcp to do about 25MB/sec by saving to a flat file. But no luck on a query that is simply selecting from a large table (53GB). I've been experimenting on Google Compute instances with various versions of SQL Server, using maxed out machines and SSDs etc. (32 cores, 200GB mem, and so on)
Is there some theoretical maximum SQL Server can handle on one connection? 25MB/sec seems stupidly slow.