如何实现100000（1万）用户并发连接到SQL服务器数据库？ [英] How to achieve 100000 (1 lakh) users concurrent connectivity to SQL server database ?

问题描述

如何实现100000（1万）用户并发连接到SQL Server数据库？我有一个场景，其中1万用户将登录到使用sql server作为后端的网站，以在同一个表上执行插入。这是实用的吗？如果是，如何实现它。应该如何设计数据库？请分享您的指导。



谢谢&此致，



Parag Deshmukh



软件工程师数据库



我尝试了什么：



我没试过。这对我来说是一个全新的挑战

How to achieve 100000 (1 lakh) users concurrent connectivity to sql server database ? I have a scenario where 1 lakh users will login to the website which is using sql server as backend, to perform insert on the same table . Is it practical? If yes how to achieve it. How should one design the database? Please share your guidance.

Thanks & Regards,

Parag Deshmukh

Software Engineer Database

What I have tried:

nothing I have tried. It is totally new challenge for me

推荐答案

数据库设计不会是你唯一的瓶颈。您还需要查看查询，每秒要支持的查询数量，性能，发送给请求者的数据量，...



您还需要Web服务器和SQL Server之间可以处理该流量的基础架构。您可能需要多个SQL Server来处理这种流量并加载多个Web服务器。



这个设计不是你想要的第一次走向正确，你也不会把它从论坛中拿出来。这是一项咨询工作，您可以与之前完成此类工作的人员一起工作，并为您设计。

The database design isn't going to be you're only bottleneck. You also need to look at queries, the number of queries you're going to support per second, their performance, how much data you're sending back to the requestors, ...

You also need infrastructure between the web server and SQL Server that can handle that amount of traffic. Chances are you're going to need multiple SQL Servers to handle this kind of traffic and load along with multiple web servers.

This design isn't something you're going to get right the first time and you're not going to get it out of a forum either. This is a consulting job where you get with people that have done this kind of work before and can design it for you.

这篇关于如何实现100000（1万）用户并发连接到SQL服务器数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！