BCM Capacity

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bigmoe - 15 Feb 2008 04:06 GMT

I have installed SQL Express 2005 SP2 on a SBS2003 and created a BCM 2007
database on the server to share out over the network. My question is this;
What are the practical capacity limits for this database. I know MS
recommnends use of BCM for under twenty users, but is there a limit for
number of records or databse size?

Reply to this Message

Lon Orenstein - 17 Feb 2008 23:26 GMT

Nobody has reported a limit, other than the 4GB limit for the file size.
We've got 40,000+ contacts in our marketing database but virtually no
history, and it's about 3GB.

The practical limit for a full production db is more dependent on your
hardware and LAN. Having 4GB of RAM on the server, 2GB on each client PC,
and a fast LAN will help a lot. Increasing the polling interval could also
help performance a lot.

HTH,
Lon

___________________________________________________________
Lon Orenstein
pinpointtools, llc
Lon@pinpointtools.com
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
www.pinpointtools.com

>I have installed SQL Express 2005 SP2 on a SBS2003 and created a BCM 2007
> database on the server to share out over the network. My question is
> this;
> What are the practical capacity limits for this database. I know MS
> recommnends use of BCM for under twenty users, but is there a limit for
> number of records or databse size?

Reply to this Message