In the last round of trial, this problem didn't generate any event log errors, but I can see many of these errors in the log. Do you think this might be the cause?:
Unexpected error occurred in API call to Controller: CMS.ApplicationDashboard.ApiControllers.LiveTileController, Action: Get
Message:
WITH AllData AS
(
SELECT *, ROW_NUMBER() OVER (ORDER BY ContactLastName) AS [CMS_RN] FROM OM_Contact WHERE [ContactSiteID] = @ContactSiteID AND [ContactCreated] > @ContactCreated
)
SELECT , (SELECT COUNT() FROM AllData) AS [CMS_TOT] FROM AllData WHERE CMS_RN BETWEEN 1 AND 1 ORDER BY CMS_RN
Caused exception:
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Exception type: System.Exception
Stack Trace:
at CMS.Base.LockObject.EnterRead[OutputType](OutputType& output)
at CMS.Helpers.CachedSection1.EnterLock(TData& result)
at CMS.Helpers.CacheHelper.Cache[TData](Func
1 loadMethod, CacheSettings settings)
at CMS.ApplicationDashboard.ApiControllers.LiveTileController.Get(Guid guid)
at lambda_method(Closure , Object , Object[] )
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.b__c(Object instance, Object[] methodParameters)
at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func`1 func, CancellationToken cancellationToken)