locked
CRM 2011 Slow RRS feed

  • Question

  • CRm has been intermittently slow when loading grids & ribbons but today it has come to a screeching halt.  I have an onpremise installation of CRM 2011, windows 2008 SP2 on one box, SQl 2008 SP2 with SSRS on another box, 70+ outlook clients with office 2010 x64 + mixture of crm 4 & crm 2011. 

    I continue to see the following error in my event viewer on the CRM server:

    create table #ObjectsIds (ObjectId uniqueidentifier); create NONCLUSTERED index ndx_ObjectsIds_objId on #ObjectsIds (ObjectId ASC); insert into #ObjectsIds select POA.ObjectId from PrincipalObjectAccess POA join SystemUserPrincipals sup on POA.PrincipalId = sup.PrincipalId where sup.SystemUserId = 'dc0bc172-1d0a-e011-b5ca-00155d01150d' and POA.ObjectTypeCode = 4200 and ((POA.AccessRightsMask|POA.InheritedAccessRightsMask) & 1) = 1; insert into #ObjectsIds select ActivityId from [Email] where OwnerId in (select pem.PrincipalId from PrincipalEntityMap pem join SystemUserPrincipals sup on pem.PrincipalId = sup.PrincipalId where sup.SystemUserId = 'dc0bc172-1d0a-e011-b5ca-00155d01150d' and pem.ObjectTypeCode = 4200) insert into #ObjectsIds select ActivityId from [Email] where owningbusinessunit in (select BusinessUnitId from SystemUserBusinessUnitEntityMap where SystemUserId = 'dc0bc172-1d0a-e011-b5ca-00155d01150d' and ObjectTypeCode = 4200) select top 2 "email0".Compressed as "compressed" , "email0".ActualDurationMinutes as "actualdurationminutes" , "email0".IsRegularActivity as "isregularactivity" , "email0".ReadReceiptRequested as "readreceiptrequested" , "email0".ActualStart as "actualstart" , "email0".Category as "category" , "email0".DeliveryReceiptRequested as "deliveryreceiptrequested" , "email0".CreatedOnBehalfBy as "createdonbehalfby" , "email0".ImportSequenceNumber as "importsequencenumber" , "email0".RegardingObjectId as "regardingobjectid" , "email0".Notifications as "notifications" , "email0".OwningTeam as "owningteam" , "email0".IsWorkflowCreated as "isworkflowcreated" , "email0".ExchangeRate as "exchangerate" , "email0".Sender as "sender" , "email0".OwnerId as "ownerid" , "email0".ToRecipients as "torecipients" , "email0".CreatedOn as "createdon" , "email0".IsBilled as "isbilled" , "email0".OverriddenCreatedOn as "overriddencreatedon" , "email0".CreatedBy as "createdby" , "email0".PriorityCode as "prioritycode" , "email0".ModifiedOnBehalfBy as "modifiedonbehalfby" , "email0".ScheduledEnd as "scheduledend" , "email0".ActivityTypeCode as "activitytypecode" , "email0".Description as "description" , "email0".OwningBusinessUnit as "owningbusinessunit" , "email0".ScheduledDurationMinutes as "scheduleddurationminutes" , "email0".StateCode as "statecode" , "email0".Subcategory as "subcategory" , "email0".SubmittedBy as "submittedby" , "email0".ModifiedOn as "modifiedon" , "email0".ActualEnd as "actualend" , "email0".Subject as "subject" , "email0".ServiceId as "serviceid" , "email0".UTCConversionTimeZoneCode as "utcconversiontimezonecode" , "email0".MessageId as "messageid" , "email0".DirectionCode as "directioncode" , "email0".MimeType as "mimetype" , "email0".OwningUser as "owninguser" , "email0".ActivityId as "activityid" , "email0".StatusCode as "statuscode" , "email0".DeliveryAttempts as "deliveryattempts" , "email0".ModifiedBy as "modifiedby" , "email0".ScheduledStart as "scheduledstart" , "email0".TrackingToken as "trackingtoken" , "email0".TimeZoneRuleVersionNumber as "timezoneruleversionnumber" , "email0".TransactionCurrencyId as "transactioncurrencyid" , "email0".CreatedOnBehalfByYomiName as "createdonbehalfbyyominame" , "email0".CreatedOnBehalfByName as "createdonbehalfbyname" , "email0".RegardingObjectIdYomiName as "regardingobjectidyominame" , "email0".RegardingObjectIdName as "regardingobjectidname" , "email0".RegardingObjectTypeCode as "regardingobjecttypecode" , "email0".OwnerIdYomiName as "owneridyominame" , "email0".OwnerIdType as "owneridtype" , "email0".OwnerIdName as "owneridname" , "email0".CreatedByYomiName as "createdbyyominame" , "email0".CreatedByName as "createdbyname" , "email0".ModifiedOnBehalfByYomiName as "modifiedonbehalfbyyominame" , "email0".ModifiedOnBehalfByName as "modifiedonbehalfbyname" , "email0".ModifiedByName as "modifiedbyname" , "email0".ModifiedByYomiName as "modifiedbyyominame" , "email0".TransactionCurrencyIdName as "transactioncurrencyidname" from Email as "email0" join ActivityParty as "activityparty1" on ("email0".ActivityId = "activityparty1".ActivityId and (("activityparty1".ParticipationTypeMask = 1 and "activityparty1".PartyId = 'dc0bc172-1d0a-e011-b5ca-00155d01150d'))) where ("email0".ActivityId in (select distinct ObjectId from #ObjectsIds) and ("email0".DirectionCode = 1 and (("email0".StatusCode = 6 or "email0".StatusCode = 7)))) and (("activityparty1".OwnerId in (select pem.PrincipalId from PrincipalEntityMap pem join SystemUserPrincipals sup on pem.PrincipalId = sup.PrincipalId where sup.SystemUserId = 'dc0bc172-1d0a-e011-b5ca-00155d01150d' and pem.ObjectTypeCode = 4200) or "activityparty1".OwningBusinessUnit in (select BusinessUnitId from SystemUserBusinessUnitEntityMap where SystemUserId = 'dc0bc172-1d0a-e011-b5ca-00155d01150d' and ObjectTypeCode = 4200) or "activityparty1".ActivityId in (select POA.ObjectId from PrincipalObjectAccess POA join SystemUserPrincipals sup on POA.PrincipalId = sup.PrincipalId where sup.SystemUserId = 'dc0bc172-1d0a-e011-b5ca-00155d01150d' and POA.ObjectTypeCode = 4200 and ((POA.AccessRightsMask|POA.InheritedAccessRightsMask) & 1) = 1))) order by "email0".ActivityId asc; drop table #ObjectsIds

     

    Am I being hacked?

    Monday, June 13, 2011 5:11 PM

All replies

  • Whoa! Ok, there are better ways to see if your being hacked.

    But the error seems to be similar to odd SQL errors in 4.0 when certain custmizations were configured.

    Do you have many of these?

     


    Curtis J Spanburgh
    Wednesday, June 22, 2011 8:14 PM
    Moderator
  • Hi Melissa,

    Did you manage to sort out your performance issues. We are also running CRM 2011 UR 3 and have performance issues when loading views and searching. The event log of the CRM server contains "MSCRMPlatform" warnings and these typically mention "Query execution time of 10.3 seconds exceeded the threshold of 10 seconds", with a similar SQL query to the one you have. Ours is slecting incidents though.I am about to open a ticket with MS.

    Thanks, Neil

    Wednesday, November 2, 2011 9:43 AM