Best Guidline to Avoid the operation and deadlock error

Question

Hi Guys,

I need help and support to configure the sql server for following Transaction details,

we running the 4000 thousand records Insert Query per second

we are running the 15000 thousand select query per second

Note all this are Machine data.

So we need the sql server configuration guideline for this transaction.

Please share the answers and help me to resolve this server configuration.

Answer 1

without the full schema, update and queries, network configuration, number of clients, etc. no one can tell you. Even if supplied, it would be beyond the scope of this forum.

the hardware vendors publish benchmarks on known configurations. contact your vendor.

as this would be a high performance configuration. you could contact your Microsoft rep to build and test a prototype.

some benchmarks:
https://www.tpc.org/tpch/results/tpch_perf_results5.asp

click a configuration and click on executive summary to get the hardware configuration