問題描述

我正在設置一個應用程序，我正在考慮購買 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.

這篇關于SQL Server - 我*真正*需要多少用戶?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！