umbraco V 7.3.3 my hosting tell me umbraco load/high resource utilization Database
Your hosting account has been investigated by our administrators due to excessive load/high resource utilization which includes high CPU utilization and memory consumption produced by your MSSQL database queries.
We regret to inform you that based on the excessive resource utilization, we have determined that your account is not a good fit for our Shared hosting environment. Please review your account and take all necessary actions to isolate this problem.
exec spexecutesql N'SELECT cmsPropertyData.* FROM cmsPropertyData INNER JOIN cmsPropertyType ON cmsPropertyData.propertytypeid = cmsPropertyType.id INNER JOIN (SELECT cmsContent.nodeId, cmsContentVersion.VersionId FROM [cmsDocument] INNER JOIN [cmsContentVersion] ON [cmsDocument].[versionId] = [cmsContentVersion].[VersionId] INNER JOIN [cmsContent] ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId] INNER JOIN [umbracoNode] ON [cmsContent].[nodeId] = [umbracoNode].[id] LEFT OUTER JOIN [cmsDocument] [cmsDocument2] ON ([cmsDocument2].[nodeId]=[cmsDocument].[nodeId] AND [cmsDocument2].[published]=1) INNER JOIN ( SELECT nodeId FROM (SELECT ROWNUMBER() OVER (ORDER BY Path) petarn, cmsDocument.nodeId FROM [cmsDocument] INNER JOIN [cmsContentVersion] ON [cmsDocument].[versionId] = [cmsContentVersion].[VersionId] INNER JOIN [cmsContent] ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId] INNER JOIN [umbracoNode] ON [cmsContent].[nodeId] = [umbracoNode].[id] LEFT OUTER JOIN [cmsDocument] [cmsDocument2] ON ([cmsDocument2].[nodeId]=[cmsDocument].[nodeId] AND [cmsDocument2].[published]=1) WHERE ([umbracoNode].[nodeObjectType] = @0) AND (cmsDocument.newest = 1) ) petapaged WHERE petarn>@1 AND petarn<=@2 ) temp ON cmsDocument.nodeId = temp.nodeId WHERE (([umbracoNode].[nodeObjectType] = @3)) AND (cmsDocument.newest = 1) ) as docData ON cmsPropertyData.versionId = docData.VersionId AND cmsPropertyData.contentNodeId = docData.nodeId LEFT OUTER JOIN cmsDataTypePreValues ON cmsPropertyType.dataTypeId = cmsDataTypePreValues.datatypeNodeId',N'@0 nvarchar(40),@1 bigint,@2 bigint,@3 nvarchar(40)',@0=N'c66ba18e-eaf3-4cff-8a22-41b16d66a972',@1=0,@2=1000,@3=N'c66ba18e-eaf3-4cff-8a22-41b16d66a972'
umbraco V 7.3.3 my hosting tell me umbraco load/high resource utilization Database
Your hosting account has been investigated by our administrators due to excessive load/high resource utilization which includes high CPU utilization and memory consumption produced by your MSSQL database queries.
We regret to inform you that based on the excessive resource utilization, we have determined that your account is not a good fit for our Shared hosting environment. Please review your account and take all necessary actions to isolate this problem.
exec spexecutesql N'SELECT cmsPropertyData.* FROM cmsPropertyData INNER JOIN cmsPropertyType ON cmsPropertyData.propertytypeid = cmsPropertyType.id INNER JOIN (SELECT cmsContent.nodeId, cmsContentVersion.VersionId FROM [cmsDocument] INNER JOIN [cmsContentVersion] ON [cmsDocument].[versionId] = [cmsContentVersion].[VersionId] INNER JOIN [cmsContent] ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId] INNER JOIN [umbracoNode] ON [cmsContent].[nodeId] = [umbracoNode].[id] LEFT OUTER JOIN [cmsDocument] [cmsDocument2] ON ([cmsDocument2].[nodeId]=[cmsDocument].[nodeId] AND [cmsDocument2].[published]=1) INNER JOIN ( SELECT nodeId FROM (SELECT ROWNUMBER() OVER (ORDER BY Path) petarn, cmsDocument.nodeId FROM [cmsDocument] INNER JOIN [cmsContentVersion] ON [cmsDocument].[versionId] = [cmsContentVersion].[VersionId] INNER JOIN [cmsContent] ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId] INNER JOIN [umbracoNode] ON [cmsContent].[nodeId] = [umbracoNode].[id] LEFT OUTER JOIN [cmsDocument] [cmsDocument2] ON ([cmsDocument2].[nodeId]=[cmsDocument].[nodeId] AND [cmsDocument2].[published]=1) WHERE ([umbracoNode].[nodeObjectType] = @0) AND (cmsDocument.newest = 1) ) petapaged WHERE petarn>@1 AND petarn<=@2 ) temp ON cmsDocument.nodeId = temp.nodeId WHERE (([umbracoNode].[nodeObjectType] = @3)) AND (cmsDocument.newest = 1) ) as docData ON cmsPropertyData.versionId = docData.VersionId AND cmsPropertyData.contentNodeId = docData.nodeId LEFT OUTER JOIN cmsDataTypePreValues ON cmsPropertyType.dataTypeId = cmsDataTypePreValues.datatypeNodeId',N'@0 nvarchar(40),@1 bigint,@2 bigint,@3 nvarchar(40)',@0=N'c66ba18e-eaf3-4cff-8a22-41b16d66a972',@1=0,@2=1000,@3=N'c66ba18e-eaf3-4cff-8a22-41b16d66a972'
There's a substantial amount of changes fixes since your version: https://our.umbraco.com/download/releases/compare?from=7.3.3&to=7.11.1
I'd recommend upgrading and see if it solves your problem.
is working on a reply...