BCM Slow with converted ACT data

C

Cgal

We have a 2007 BCM database with approximately 8000 contact in it that was
converted from ACT. I have been getting numerous complaints from the sales
folks indicating that BCM is slow or times out.

I am a SQL Server DBA and I traced the actity hitting the BCM database using
profiler. I found that the following statement is causing the application
the timeout:

Select ID, ContactID, IsNamed, PropertyMAPIID, NamePropSet, NameKind, Name,
PropertyValue, MAPIType from ContactAdditionalPropertyBag

I ran this query outside of BCM in SQL Server Management Studio and it
returned over 500,000 rows and took over 2 minutes to return. I am not
familiar with the BCM database but something seems wrong. Is this a
conversion issue? What data is stored in this table? Does 500,000 rows in
the ContactAdditionalPropertyBag table make sense with only 8000 contacts.

Please help. The salesmen are about to bail out on this product.

Thanks!

Chris
 
Top