SQL Server - 我*真正*需要多少用户?
我正在设置一个应用程序，我正在考虑购买 SQL Server 的许可证.我的问题很简单(虽然答案可能很复杂...)
I'm setting up an application, and I'm looking into purchasing a license for SQL Server. My question is pretty simple (though may have a complicated answer...)
对于 SQL Server，我真正需要多少个用户帐户?
How many users accounts do I really need, for SQL Server?
在我看来，我会提供一个主管理帐户，可能是 2 或 3 个用户帐户，然后是一个基于应用程序的帐户.
The way I see it, I'd give one master administration account, maybe 2 or 3 user accounts, and then one application-based account.
我的应用程序可能有大约 30-40 个用户，很少有可能有 4-5 人同时使用.但正如我所见，我设置了一个包含 30-40 个帐户的 BLL - BLL 将拥有 SQL 帐户，所有 30 个帐户都将使用该帐户通过...查询数据库.
My application will likely have about 30-40 users, with the rare possibility of having 4-5 people being simultaneous users. But as I see it, I'd set up a BLL with the 30-40 accounts - and the BLL would have the SQL account, that all 30 accounts would use to query the DB through...
我只是想知道人们对此有何看法.这是要走的路，还是我对这里的架构有错误的想法?
I'm just wondering what people's take on this is. Is that the way to go, or do I have the wrong idea of architecture here?
推荐答案
您的案例称为多路复用，特殊注意事项 使用中间件、事务服务器和多层架构:
Your case is called Multiplexing ans is covered in the special considerations Using Middleware, Transaction Servers, and Multitiered Architecture:
有时组织会发展使用各种网络场景硬件和/或软件的形式减少设备或用户的数量直接访问或使用特定服务器上的软件，通常称为多路复用"或池化"硬件或软件.使用这种多路复用或池化硬件和/或软件不会减少客户端访问许可证的数量访问或使用 SQL 所需的 (CAL)服务器软件.需要 CAL每个不同的设备或用户多路复用或汇集软件或硬件前端.这仍然是真的无论硬件有多少层或服务器之间存在软件运行 SQL Server 和客户端最终使用其数据的设备，服务或功能
Sometimes organizations develop network scenarios that use various forms of hardware and/or software that reduce the number of devices or users that directly access or use the software on a particular server, often called "multiplexing" or "pooling" hardware or software. Use of such multiplexing or pooling hardware and/or software does not reduce the number of client access licenses (CALs) required to access or use SQL Server software. A CAL is required for each distinct device or user to the multiplexing or pooling software or hardware front end. This remains true no matter how many tiers of hardware or software exist between the server running SQL Server and the client devices that ultimately use its data, services, or functionality
底线:您需要为每个用户提供一个 CAL，总共需要 35-45 个许可证.
Bottom line: you need one CAL for every user, to a toal of 35-45 licenses.
相关文章