Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Kalyan 2 posts 73 karma points
    Jan 25, 2021 @ 17:54
    Kalyan
    0

    Property query occupies SQl database 100% DTU

    Hi Team, we recently identified the below query occupies 100% DTU, any idea why this suddenly occurred.

    SELECT [umbracoPropertyData].[id] AS [Id], [umbracoPropertyData].[versionId] AS [VersionId], [umbracoPropertyData].[propertyTypeId] AS [PropertyTypeId], [umbracoPropertyData].[languageId] AS [LanguageId], [umbracoPropertyData].[segment] AS [Segment], [umbracoPropertyData].[intValue] AS [IntegerValue], [umbracoPropertyData].[decimalValue] AS [DecimalValue], [umbracoPropertyData].[dateValue] AS [DateValue], [umbracoPropertyData].[varcharValue] AS [VarcharValue], [umbracoPropertyData].[textValue] AS [TextValue] FROM [umbracoPropertyData] WHERE ([umbracoPropertyData].[versionId] IN

    Thanks Kalyan.G

  • Kalyan 2 posts 73 karma points
    Jan 26, 2021 @ 10:57
    Kalyan
    1

    Issue got solved after manual rebuild indexes on that table. Thanks.

Please Sign in or register to post replies

Write your reply to:

Draft