SQL Server Performance

MAX CONNECTIONS

Discussion in 'SQL Server Clustering' started by mibsun, Nov 15, 2003.

  1. mibsun New Member

    Hi ,
    Is anyone aware of Max Connections a Microsoft SQL Server can serve .We are getting random disconnections to the SQL Database .Any resources pointed to such issue welcome .
    Thanks
    mibsun
  2. satya Moderator

    Its available with maximum value of configured connections.

    Check the current activity and profiler to see the activity on the Server.
    And also captuer PERFMON counters for assessment such as Physical disk, user connections, memory, process, processor etc.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. Twan New Member

    if the option "user connections" is set to the default, then it would be 32767 per instance

    check using sp_configure

    This should not reult in disconnections though, instead it would result in an error message when attempting to log on

    There is nothing in the error log? no errors back to the client? nothing in the event log? No other network type issues, e.g. exchange client disconnects randomly?


    Cheers
    Twan

Share This Page