SQL Server Performance Forum – Threads Archive
Max Concurrent Users
Does anyone know of a formula/guideline that would dictate how many concurrent users should be allowed on any given sql 2000 server? Mike L. WarnerIt depends on max worker threads configuration which is I believe default 255…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
SQL Server 2000 supports 32,767 connections per instance. Also you may be aware we can have maximum 16 instances per server that brings maximum number of client connections per server is 524,272. (this is purely for Enterprise edition).
BOL
quote:
The SQL Server service allocates computer resources effectively between multiple concurrent users. It also enforces business rules defined in stored procedures and triggers, ensures the consistency of the data, and prevents logical problems such as having two people trying to update the same data at the same time.
The SQL Server service allocates computer resources effectively between multiple concurrent users. It also enforces business rules defined in stored procedures and triggers, ensures the consistency of the data, and prevents logical problems such as having two people trying to update the same data at the same time.
Again this depends on the amount of physical memory available on the server.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
but isn’t there some sort of guideline formula (perhaps based on your hardware config) that tells you roughly how many users is a potential limit? Mike L. Warner
This has been divided into various parts within the books online, true that there isn’t direct answer for this. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
We had issues with number active connections exceeding 255 and MS don’t change this configuration unless it is neccessary and recommended by them… Check the following… Ken Henderson’s WebLog : Max worker threads
http://blogs.msdn.com/khen1234/archive/2005/11/07/489778.aspx
How to determine proper SQL Server configuration settings
http://support.microsoft.com/kb/319942
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
thank you all for your input, it has been helpful. <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br /><br />Mike L. Warner
Just for curiosity, I would like to know why you need such information. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>