Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  MSSQL Server 2008 Express Concurrent Connections

Author  Topic  phylox Starting Member 2 Posts Posted - 2010-07-22 : 08:40:45 Would anyone happen to know if there is a limit on concurrent connections with SQL Server 2008 Express? I believe it was 32687 or somewhere around that but wasn't sure if this applied to the express edition. We are going to use this on a Production environment where we get around 6-7k hits per day. Our current host has the SQL server sitting on it's own box with only 768mb ram and the database size is about 5gb, which the log files are taking up a good 2gb of it. SQL Server Express 2008 R2 as far as I know has a limit of only one processor and up to 1gb for memory. I think we should be fine, but what are your thoughts?