SQL Server Performance

Max Concurrent Users

Discussion in 'Getting Started' started by mwarner67, May 22, 2007.

  1. mwarner67 New Member

    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. Warner
  2. MohammedU New Member

    It 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.
  3. satya Moderator

    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.

    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.
  4. mwarner67 New Member

    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
  5. satya Moderator

    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.
  6. MohammedU New Member

    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.
  7. mwarner67 New Member

    thank you all for your input, it has been helpful. <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />Mike L. Warner
  8. satya Moderator

    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.

Share This Page