Hi !
What is the max number of connections in sql server 2000 MSDE
I have found three opinions on the web: 5,8 and unlimited(32,768...)
Which is true
/hakan
Max connections in sql server 2000 MSDE
Hot Topic
- Datasource Webservice
- List of All SSIS packages stored in MSDB
- SQL replication between 2 SQL servers across shared T1
- Formatting text in using Report Designer
- Using SMO to backup / restore a SqlExpress database
- Business Scorecard Integration with SQL server 2000/2005
- 64-bit issue
- Connecting a web app to sql server
- TSQL or CLR for a complex query?
- 'Convert' and 'MAX' Functions
SQL Server
- Writing to SQL Database
- reportviewer with 3 datatable in dataset's ?
- Syntax for "In" Operator
- Very high transaction log growth in SQL Server 2005 (RTM version)
- Applying the updates to SQL Mobile Server?!
- WMI Provider Error
- Tx replication works in 2000 but not in 2005?
- "Beta period is over" (June 2005 CTP)
- Reason for Limitation and Work around for referencing Table Group fields in Footer!
- BUG? Extracting Data Stored in Multiple Languages
Max connections in sql server 2000 MSDE
Gabriel PURAN
I don't think there is any limit to the number of connections. . .
there is a throttle on performance based on number of concurrent connections. the actual number that triggers the throttle i beleive depends on build/sp.
that being said. . . if you build your app correctly and design you database properly, you could probably service 100 to 200 concurrent users of your windows app without seeing a performance hit and thousands of concurrent users of a web app. thats just an opinion, don't ask me to prove it. but I will keep repeating that until someone from MS tells me differently.
but, build you app/db improperly and it doesnt matter which version of sql server you use. performance is going to suck any way.