Heavy Load

time to read 1 min | 88 words

I just put SQL Server through a stress test that had it copy several giga bytes over a network. It tooks over two hours, but I think most of it was network traffic. The actual inserts took relatively little, although toward the end I noticed SQL Server slurping memory like it was free candy (ended on ~1.4Gb RAM taken).
I then run a query on all of that data, which returned much quicker than I expected. The more I work with it, the more I like it.