Is a million writes/sec a large number? I guess it's all relative, but I'd consider it a fairly large number. Our peak transfers for SQLServerCentral are in the hundreds/sec, though we're not really a busy database server. Some of you might have much higher numbers, and if you're in the 100,000/sec and can let us know, I'm sure others would be interested in hearing about your experiences.

I ran across a piece on the Uber database infrastructure that I found impressive. No, Uber doesn't use SQL Server (they use Cassandra), but they have worked to build a large scale infrastructure. Their goals:

Read the rest of "One Million" at SQLServerCentral.