Limit in connections

Limit in connections

• Slater

  Also, find the word "governor" on these pages: http://www.microsoft.com/technet/technetmag/issues/2005/05/BetaBox/default.aspx ShowStepTwo=true http://www.microsoft.com/technet/community/chats/trans/sql/SQL_081004.mspx http://msdn.microsoft.com/msdnmag/issues/04/09/expresseditions/default.aspx http://msdn.microsoft.com/theshow/transcripts/Episode049Transcript.aspx wrote in message news:bd308738-350c-4cd0-a99e-0e8690010eb3@discussions.microsoft.com... > is there a limit in concurrent connection to SQL Server Express Edition > > thanks > > ~Walther >
  

• Ted Hoffman

  SQL Server Express 2005 doesn't have any workload governor to throttle connections so there is no limit in number of concurrent connections (as opposed to MSDE)
  
  Here's a piece from BOL:
  
  SQL Server Express and MSDE Limitations

  The following table lists the limits that have been set for MSDE and SQL Server Express databases.

  Limitation	MSDE Limit	SQL Server Express Limit
  Concurrent workload governor (throttle)	Yes	No
  Database size limitation	2 GB	4 GB
  RAM support	2 GB	1 GB
  SMP support	2 (or 1 if MSDE is run on Windows 98 or Windows Millennium Edition)	1

  Note:
  In MSDE, the Workload Governor (also known as the throttle) caused performance limitations as the number of concurrent users increased. SQL Server Express does not have a Workload Governor.

  
  
  

• jbln

  No. http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx http://www.aspfaq.com/sql2005/show.asp id=8 wrote in message news:bd308738-350c-4cd0-a99e-0e8690010eb3@discussions.microsoft.com... > is there a limit in concurrent connection to SQL Server Express Edition > > thanks > > ~Walther >
  
• Limit in connections