Determining the Maximum Number of Connections to SQL Server 2000

Rating:

(0)

Richard Waymire

SQL Server Magazine

InstantDoc ID #23323

How many client connections does SQL Server 2000 support?

SQL Server 2000 supports 32,767 connections per instance. You can run 16 instances per node, so the maximum number of client connections per server node is 524,272. Note that unless you have SQL Server 2000 Enterprise Edition, you have to pay separately to use each of the 16 instances on one computer.

Fr...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Could you please explain what does a node means and what an instance of node means. Also i would like to know how is this relateed to the user licence

rajneesh4/20/2004 7:53:34 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

Tuna Helper - Tuning SQL Statements: A Proven Process for SQL Server Environments
A White Papers by Confio

The Essential Guide to Mission-Critical Microsoft SQL Server
A Essential Guides by EMC

A Business Case for Lowering Enterprise Total Cost of Ownership - Microsoft SQL Server for SAP on HP Integrity Servers
A White Papers by Hewlett-Packard

Check Out the Industry-Leading CA Erwin Data Modeler—Free 15-Day Trial
A Downloads by CA/ERwin

Field level security

I need to secure certain fields, Name, SSN, for example, in a table's rows. I know about SQL encryption, but is there another way to secure the indiv...

Paid Case Study of Sr. IT Professionals in $1B+ companies who migrated from Sybase/ Oracle to SQL Server 2008
Database logins
Registry value

GOOGLE LINKS

SQL Server Magazine

Browse By Category

Determining the Maximum Number of Connections to SQL Server 2000

Add a Comment

Related Resources

Field level security

More Posts

Essential Guides

Web Seminars

eBooks

eLearning Series