Connect Enterprise - MS SQL Requirements

[Guest]

Hello,

I've looked through all the documentation I could find and also searched both the knowledgebase and the forum to find answers. What I'm looking for is granular "rule of thumb type data" for instance like in the format of:

http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19524&sliceId=2

Anyway:

1. Does anyone have general MS SQL database file size metrics in regard to Adobe Connect Enterprise? I know it's a tough question with many answers based on how large of an install, how many users, etc. However does anyone have metrics based on what they've experienced?

2. I have seen the Adobe server requirements for a Connect install, however, what would be the server requirements for a second server used as a SQL server to support the Connect install? Regarding MS SQL server to support a Connect install, should I use the requirements for Adobe Connect as a rule of thumb or the MS SQL Server 2005 requirements instead?

Thanks!

[Guest]

1) The database file is tiny; the content is the larger storage hog and is stored in a file system. I believe the database on one of our installs is about 1 MB with over 1,000 users.

2) We currently have it set up with SQL 2000, but have started discussing the migration to SQL 2005 on the database server. I would go with 2005 to start with just because it's one less migration, but I couldn't say based on experience.

[Guest]

T.,

Thanks for the knowledgeable insight. For some reason my topic subscription got broken and I didn't know you responded until I checked manually just now. Anyway, thanks a bunch!

-Jun

[Guest]

My coworker just corrected me - our database is 410MB with 1,860 users. Thanks John!