Microsoft.AspNet.SignalR.SqlServer: setting TableCount in SqlScaleoutConfiguration to > 1 results in very poor performance

[doboczyakos]

Expected behavior

Same response time when TableCount = 1 and TableCount = 10

Actual behavior

Response time is cca 100x higher when TableCount = 10

Steps to reproduce

Send messages by a SignalR hub with SQL backplane to a client
Measure the time between the message is given to the hub and arrives at the client
Set TableCount to 10 and do the same measurement