how do i get SQL Server maximum supported connections.??

• Noman Tariq

  SSCommitted

  Points: 1750

  More actions

  July 22, 2009 at 5:33 am

  #134132

  Hi Everybody,

  hope all are enjoying their time.

  i have a question and guidelines about to test sql server connection supports, i mean we have an application and we are expecting millions of users to be connected to our DB through this application.

  so i need to test my DB that upto how many connections it will support in real time.

  give me any guideline to check my DB connection support.

  Thanks,

  Noman

• dba_pkashyap

  Hall of Fame

  Points: 3336

  More actions

  July 22, 2009 at 6:00 am

  #1028223

  I checked it in my earlier comp., you can do that using DMV's

  try to check it using sys.dm_exec_connections or sys.dm_exec_sessions with some cond.'s