CRM Mobile and MSSQL CPU Useage

[Tracey]

Hi there
Since we installed CRMMobile our (new) server has been SO SLOW!
SqlServer is taking anywhere from 69 - 99% cpu time (mostly around 99)
I have run sql profiler and discovered that many times a second the
following transactions are running:

exec sp_executesql N'SELECT 
recipientAddr,recipientSrvcPort,sourceAddr,sourceSrvcPort, 
MIN(arrivalDate) as minArrivalDate, count(*) as messageCount FROM 
vwInBoundQueue WHERE recipientAddr=@recipientAddr AND 
recipientSrvcPort=@recipientSrvcPort GROUP BY 
sourceAddr,sourceSrvcPort,recipientAddr,recipientSrvcPort ORDER BY 
minArrivalDate',N'@recipientAddr 
nvarchar(256),@recipientSrvcPort nvarchar(256)',@recipientAddr=N'[URL unfurl="true"]http://businesssolutions.microsoft.com/CRM',@recipientSrvcPort=N'http://schemas.microsoft.com/BusinessSolutions/2003/CRM/Mobile.wsdl:CRMMobileService,CRMMobileMsgBus'[/URL]

AND

exec sp_executesql N'SELECT 
recipientAddr,recipientSrvcPort,sourceAddr,sourceSrvcPort, 
msgId FROM vwInBoundQueue WHERE recipientAddr=@recipientAddr AND 
recipientSrvcPort=@recipientSrvcPort ORDER BY 
arrivalDate',N'@recipientAddr nvarchar(256),@recipientSrvcPort nvarchar(256)',@recipientAddr=N'urn://mbsmobility/',@recipientSrvcPort=N'CRM/Administration/DeviceRegistration'

I guestimate these two procedures are executed at least 30x/second.
I stopped the Mobile Integration Service and the problem went away, however we need to have MIS running to sync, and the problem returned when the service was re-started.

How can I stop this from hogging my resources?????
What are these queries specifically doing??



Tracey
Remember... True happiness is not getting what you want...

Its wanting what you have got!