Top 5 Deadlocked Databases

Microsoft.SQLServer.Linux.Views.Report.TopDeadlockedDatabases (LinkedReport)

Top 5 Deadlocked Databases Report (Performance TOP Instance Report)

Knowledge Base article:

Summary

How does this report work?

The Top5 Deadlocked databases report displays one chart that shows the top 5 deadlocked databases and a tabled detailing the databases and the counter values.

The report displays a blue column for the number of deadlocks in the chosen period. The black error bar indicates the fluctuation of the counter during the reporting range. If the Error bar is small, the counter has always been around the Top value, if it is large the database had a wider varying number of deadlocks.

How to use this report?

What Parameters are offered?

Date/Time selection: Allows selecting a relative or fixed date and time range and time zone.

Management Group: Allows to choose the Management Group to run this report.

Element properties:

Base	Microsoft.SystemCenter.DataWarehouse.Report.PerformanceTop
Target	Microsoft.SQLServer.Linux.DBEngine
Accessibility	Public
Visible	True

Source Code:

<LinkedReport ID="Microsoft.SQLServer.Linux.Views.Report.TopDeadlockedDatabases" Target="SqlDiscL!Microsoft.SQLServer.Linux.DBEngine" Accessibility="Public" Visible="true" Base="DWReport!Microsoft.SystemCenter.DataWarehouse.Report.PerformanceTop">

  <ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="4">

    <Controls>

      <Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDateTimePicker" columnSpan="2">

        <ReportParameters>

          <ReportParameter name="TimeZone" binding="TimeZone">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.TimeZone</Prompt>

          </ReportParameter>

          <ReportParameter name="TimeZoneName" binding="TimeZoneName"/>

          <ReportParameter name="StartDate_BaseType" binding="StartDate_BaseType"/>

          <ReportParameter name="StartDate_BaseValue" binding="StartDate_BaseValue">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.StartDateTime</Prompt>

          </ReportParameter>

          <ReportParameter name="StartDate_OffsetType" binding="StartDate_OffsetType"/>

          <ReportParameter name="StartDate_OffsetValue" binding="StartDate_OffsetValue"/>

          <ReportParameter name="EndDate_BaseType" binding="EndDate_BaseType"/>

          <ReportParameter name="EndDate_BaseValue" binding="EndDate_BaseValue">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.EndDateTime</Prompt>

          </ReportParameter>

          <ReportParameter name="EndDate_OffsetType" binding="EndDate_OffsetType"/>

          <ReportParameter name="EndDate_OffsetValue" binding="EndDate_OffsetValue"/>

        </ReportParameters>

      </Control>

      <Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.ComboBox" columnSpan="2">

        <ReportParameters>

          <ReportParameter name="ManagementGroupId">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.ManagementGroup</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="TypeFilter">

            <Value>Microsoft.SystemCenter.ManagementGroup</Value>

          </Property>

        </Properties>

      </Control>

    </Controls>

  </ParameterBlock>

  <Parameters>

    <Parameter Name="RuleId">

      <Value>$MPElement[Name="SqlMonL!Microsoft.SQLServer.Linux.CollectionRule.DBEngine.NumberDeadlocksPerSecond"]$</Value>

    </Parameter>

    <Parameter Name="RuleInstance">

      <Value/>

    </Parameter>

    <Parameter Name="SortOrder">

      <Value>-1</Value>

    </Parameter>

    <Parameter Name="TopCount">

      <Value>5</Value>

    </Parameter>

  </Parameters>

</LinkedReport>