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.
| Author |
Topic |
|
Rekha
Starting Member
14 Posts |
 Posted - 2007-04-30 : 04:25:43
|
| Hello,We are establishing a database server for our product suite containg 14 products- these products is basically intended to be used by CAs and Accountants. my databaseserver will have 14 databases-4 are very small, 4 are complex and 6 are Very complex- there is a close intraction between all these databases.at any time there will be around 500 users using these products but since these products are seasonal there is a chance that all 500 users are connected to one database only.(but there is also a possiblity that load is equally distributed on all the databases)My product will run on intranat. My requirement is:1. What is best server configuration for hosting such type of database.(sqlserver 2005)2. How many concurrent users sqlserver supports(MSaccess supports 15 concurrent users)3. I want that if user has license for 10 users my Database should bear load of only 10 user. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-30 : 13:04:21
|
| Sql server can handle up to 32767 connections. You may need processor license (depends on app type and how does user connect to sql), check with Microsoft. |
 |
|
|
|
|
|
Planning Database on SQL Server 2005