Business Contact Manager - Strange SQL-Queries

Hello

We are using Business Contact Manager 2007 on a SQL Server 2005 and have some performance problems with it.

I have noticed, that it executes thousands and thousands of the same or similar queries. One of them is the following. It performs queries like that about 10 times a second and sometimes from multiple users.

Can anybody tell me where this query comes from and what it does?

BeginReadTransaction; select top 100 percent Field12296, Field3591, Field4089, EntityTypeCode, ActivityType, ViewRowID, IsCAO From (Select Field12296, Field3591, Field4089, EntityTypeCode, ActivityType, ViewRowID, IsCAO from OpportunityIMAPIViewForActivity v where IsDeletedLocally = 0 AND ((((IsCAO = 0) AND (ViewRowID in (160911,38964,10822,142665,11007,160087,109983,93034,66111,22157))))) UNION ALL Select Field12296, Field3591, Field4089, EntityTypeCode, ActivityType, ViewRowID, IsCAO from ProjectIMAPIViewForActivity v where IsDeletedLocally = 0 AND ((((IsCAO = 0) AND (ViewRowID in (160911,38964,10822,142665,11007,160087,109983,93034,66111,22157))))) UNION ALL Select Field12296, Field3591, Field4089, EntityTypeCode, ActivityType, ViewRowID, IsCAO from ActivityIMAPIView v where IsDeletedLocally = 0 AND ((((IsCAO = 0) AND (ViewRowID in (160911,38964,10822,142665,11007,160087,109983,93034,66111,22157)))))) as bs

I cannot provide you detailed information on that, as it is not possible to find the issue just buy reading those random queries. What I can provide you is a troubleshooting link below which has number of common issues that you face mostly with Business Contact Manager. In that link below you can look for database operation troubleshooting. This has more number of sub topics which is based on various errors. So just have a look on the same.


http://office.microsoft.com/en-us/bu...010222781.aspx