Running some monitoring on our system it appears that the same two SQL queries are constantly being run against our CRM database. My belief is that they are being triggered by the tomcat services as
1. SQL is reporting that the program name is "Microsoft JDBC Driver for SQL Server" - as far as I am aware the core eWare dll does not not rely on java
2. If the tomcat service is stopped then these queries cease to run
2. If the tomcat service is stopped then these queries cease to run
The two queries in question are
1. SELECT crmid, view_EntityName, view_RecordId, index_descriptor, territory, channel, assignedTo, createdBy FROM vEmailComposer WHERE crmid ='ENTITY-00000-0000'
2. (@P0 nvarchar(4000))SELECT epd_entityid, epd_Recordid, epd_EmailAddress FROM crmemailphonedata WITH (NOLOCK) WHERE epd_EmailAddress=@P0
ENTITY can be either company or person.
Does anyone know the exact CRM functionality which generates these queries? My suspicion is that it is the Exchange synchronisation, possibly with relation to external attendees but without access to the source code I cannot be sure.
It appears that both these queries are placing locks on the database tables which are then hindering the operation of CRM.
