SQL Server Performance


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 .
  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
  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?


Share This Page