My SQL Server databases are hosted on a highly spec'd converged platform with All Flash Storage Arrays, 40G network etc.
However, we're still unable to get more than 50MB/s Redo Rate - I need this to be in the GB/sec range.
The supporting platform can handle this - what is the bottleneck within SQL Server 2012 that stops it from maximizing the potential throughput and how can I overcome it? Even with a single-threaded process 50MB/s is poor - and totally useless given the amount of data we process.
Updates: When I'm on the server I can copy files between drives and get speeds > 1000MB/s. After reboots I see Redo Rates spike as high as 300MB/s, so I know its possible in my environment, however it quickly reduces to its norm of 50MB/s even when the Recovery queue is sitting at 400G. That takes 8 hours to drain - leading to very unhappy Clients...