SQL Server的 - 有多少用户我真的* *需要？ [英] SQL Server - How many users do I *really* need?

问题描述

我设立一个应用程序，我期待到购买许可证的SQL Server。我的问题是pretty简单（虽然可能有一个复杂的答案...）

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人是并发用户的罕见可能性。但是，当我看到它，我会成立了一个BLL与30-40帐户 - 和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?

推荐答案

您情况称为多路复用ANS覆盖在<一个href=\"http://www.microsoft.com/Sqlserver/2005/en/us/special-considerations.aspx#multiplexing\">special考虑使用中间件，事务服务器和多层体系结构：

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

有时组织发展
  使用各种网络方案
  硬件和/或软件的形式的
  减少设备或用户的数目
  直接访问或使用
  在特定服务器上的软件，常常
  所谓的复用或汇集
  硬件或软件。这样的使用
  多路复用或共用硬件
  和/或软件不减少
  客户端访问许可证的数量
  需要（的CAL）来访问或使用SQL
  服务器软件。一个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的 - 有多少用户我真的* *需要？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！