Just an update. After spec’ing up the server to 8core and running tests again, it runs fine with 250 concurrent connections, all transactions are under 3sec so we could probably go higher. Some coding changes were also made to prevent the deadlocks we saw (there was an update query using a wildcard which has now been removed in place of a clustered index & array of Id’s).
At this point the only bottleneck for us is CPU which maxes out when we try run the 500concurrent test, response times then rocket upto around 50sec. But i’m pretty happy with the improvement for now, it will get us to where we need to be. 
1 Like