Help . . .Using Small Business Server

[Anonymous]

Is it possible to use Small Business Server and the SQL Server that comes
with it for Autodesk Vault and Product Stream??

I was told that this was ill-advised and that I need a separate Server with
SQL . . . which is a huge additional cost . . . because of possible
performance issues. Our SBS is used primarily as a file repository and has
only Exchange running on it and a SQL Database for Business Information
Control coming soon. The Database should not tax the server much at all.

Any help/advise would be greatly appreciated!!

Mark N.

[Anonymous]

Whilst not being the ideal situation, I have a number of installations working this way. If you have a dual Xeon server with 4GB
RAM and loads of space, you should be OK booting in 3GB mode.

Vault and Exchange have similar requirements, and you can set in SQL Enterprise manager how mauch RAM and which processors to
prioritise for SQL - with HT dual Xeon, you have 4 virtual processors to play with! Routine maintenance of the Vault installation
should keep the database fairly small, and routine restarting of the Exchange stores.exe process and ASPnet Worker process should
deal with any memory leaks which both are prone to.

I have one site running SBS and full SQL with Vault on SQL. 9 full time Inventor users, plus some AcadE users, Active Directory
supporting 25 users and a bespoke SQL system that runs the entire business. Server is suitably beefed up and all is working OK.

HTH

John Bilton

[Anonymous]

Hi John,

Thanks for the information, very useful!

Does any of your sites have any of the following:
Exchange setup for Web access and SSL?
Product Stream setup?

Do you know the size limit for full SQL in SBS 2003?

Mark

"John Bilton" wrote in message
news:4948237@discussion.autodesk.com...
Whilst not being the ideal situation, I have a number of installations
working this way. If you have a dual Xeon server with 4GB
RAM and loads of space, you should be OK booting in 3GB mode.

Vault and Exchange have similar requirements, and you can set in SQL
Enterprise manager how mauch RAM and which processors to
prioritise for SQL - with HT dual Xeon, you have 4 virtual processors to
play with! Routine maintenance of the Vault installation
should keep the database fairly small, and routine restarting of the
Exchange stores.exe process and ASPnet Worker process should
deal with any memory leaks which both are prone to.

I have one site running SBS and full SQL with Vault on SQL. 9 full time
Inventor users, plus some AcadE users, Active Directory
supporting 25 users and a bespoke SQL system that runs the entire business.
Server is suitably beefed up and all is working OK.

HTH

John Bilton

[Anonymous]

Hi Mark.

To answer your questions briefly, no... the only PS sites we look after have a dedicated departmental server running full SQL.
Following is a link that explains the differences between different versions of SQL including their limitations. SBS comes with SQL
standard edition (on disk 5).

http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.mspx

HTH

John Bilton