The limit of 10 is based on the OS you are using. Windows 2000 Pro and Win
XP Pro have a limit of 10 concurrent connections. If you want more then 10
concurrent users you need to install the server on a Windows Server OS.
MSDE does not have a connection limitation, but MSDE has two different
limitations. The first is the database size, which is limited to 2 GB and
the second is MSDE puts a workload governor in the processing of SQL
commands. This means if you are using the server a lot MSDE will insert a
delay before processing a command. Thus as MSDE is used more its
performance gets worse which forces you to upgrade to full SQL. For most
shops I do not think that the workload governor will be a problem.
I my opinion where or not you need full SQL depends on how big your database
is getting (and if you are willing to jump to a new Vault as the old one
gets big) and if your usage of Vault is so extreme that it causes the
governor to kick in. This can be checked by looking at the server log files
or by asking MSDE using SQL Server Query Analyzer or osql.exe and run the
following T-SQL statement:
DBCC CONCURRENCYVIOLATION
As and FYI...
In my testing I have never seen the MSDE governor kick in.
Robert Angus
Autodesk
"Dave Hoder" wrote in
message news:41f058a1$1_1@newsprd01...
> As I understand it this is a limitation of MSDE. It means 10 at the same
> time, not 10 total.
>
> "John-IV8SP1" wrote in message
> news:41f0474f$1_2@newsprd01...
>> In my reading, however, it would seem that MS SQL is a requirement for a
>> vault serving >10 users, no?
>>
>>
>> "joanl" wrote in message
>> news:20500973.1105979131634.JavaMail.jive@jiveforum2.autodesk.com...
>> > Hi,
>> >
>> > We have 3 seats of I9 Series and 15 AutoCAD. It is my understanding
> that
>> we can not use the vault for all of our drawings since we only have 3
> seats
>> of Inventor. Is that true?
>> > Also, what is your opinion of the vault? Is it easy to use? Is it
>> > easy
>> to learn and setup?
>> >
>> > Thanks in advance!
>> >
>> > Joan
>>
>>
>
>