問(wèn)題描述

我正在設(shè)置一個(gè)應(yīng)用程序，我正在考慮購(gòu)買 SQL Server 的許可證.我的問(wèn)題很簡(jiǎn)單(雖然答案可能很復(fù)雜...)

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...)

對(duì)于 SQL Server，我真正需要多少個(gè)用戶帳戶?

How many users accounts do I really need, for SQL Server?

在我看來(lái)，我會(huì)提供一個(gè)主管理帳戶，可能是 2 或 3 個(gè)用戶帳戶，然后是一個(gè)基于應(yīng)用程序的帳戶.

The way I see it, I'd give one master administration account, maybe 2 or 3 user accounts, and then one application-based account.

我的應(yīng)用程序可能有大約 30-40 個(gè)用戶，很少有可能有 4-5 人同時(shí)使用.但正如我所見，我設(shè)置了一個(gè)包含 30-40 個(gè)帳戶的 BLL - BLL 將擁有 SQL 帳戶，所有 30 個(gè)帳戶都將使用該帳戶通過(guò)...查詢數(shù)據(jù)庫(kù).

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...

我只是想知道人們對(duì)此有何看法.這是要走的路，還是我對(duì)這里的架構(gòu)有錯(cuò)誤的想法?

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?

推薦答案

您的案例稱為多路復(fù)用，特殊注意事項(xiàng) 使用中間件、事務(wù)服務(wù)器和多層架構(gòu):

Your case is called Multiplexing ans is covered in the special considerations Using Middleware, Transaction Servers, and Multitiered Architecture:

有時(shí)組織會(huì)發(fā)展使用各種網(wǎng)絡(luò)場(chǎng)景硬件和/或軟件的形式減少設(shè)備或用戶的數(shù)量直接訪問(wèn)或使用特定服務(wù)器上的軟件，通常稱為多路復(fù)用"或池化"硬件或軟件.使用這種多路復(fù)用或池化硬件和/或軟件不會(huì)減少客戶端訪問(wèn)許可證的數(shù)量訪問(wèn)或使用 SQL 所需的 (CAL)服務(wù)器軟件.需要 CAL每個(gè)不同的設(shè)備或用戶多路復(fù)用或匯集軟件或硬件前端.這仍然是真的無(wú)論硬件有多少層或服務(wù)器之間存在軟件運(yùn)行 SQL Server 和客戶端最終使用其數(shù)據(jù)的設(shè)備，服務(wù)或功能

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

底線:您需要為每個(gè)用戶提供一個(gè) CAL，總共需要 35-45 個(gè)許可證.

Bottom line: you need one CAL for every user, to a toal of 35-45 licenses.

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