Home
  •  

数据库文件空间使用量预测

Microsoft.SQLServer.Windows.Views.Report.DBFilesForecast (Report)

Database Files Space Usage Forecast

Knowledge Base article:

Summary

How does this report work?

The Database Files Space Usage Forecast report displays several charts with the following performance items:

The report displays a separate chart for every selected object or a group of objects. Note that this report works with Windows objects only.

How to use this report?

1. Open the report menu in the Operations Manager.

2. Add an object or a group of objects to the report.

3. Select the period and the corresponding time zone for the report.

4. Select the number of days for the consumption forecast.

5. Click Run button. The report data will be displayed.

Element properties:

AccessibilityInternal
VisibleTrue

Report Localization:

R.ManagementGroupComputer管理组: ##(MG_NAME)## 计算机: ##(COMP_NAME)##
R.ManagementGroupComputerInstance管理组: ##(MG_NAME)## 计算机: ##(COMP_NAME)## 实例: ##(INST_NAME)##
R.Consumer使用者
R.ConsumptionForecastGB消耗预测(GB)
R.FinalAvgFreeSpacePercent最后平均可用空间(\%)
R.FinalSizeGB最终大小(GB)
R.FinallyConsumedGB最终使用量(GB)
R.GrowthGB增长(GB)
R.InitialAvgFreeSpacePercent初始平均可用空间(\%)
R.InitialSizeGB初始大小(GB)
R.InitiallyConsumedGB初始使用量(GB)
R.InstanceName实例
R.SizeGB大小(GB)
R.SizeForecastGB大小预测(GB)
R.ReportTitle数据库文件空间使用量预测
R.Summary摘要
R.MostGrowingSpaceConsumers增长最快的前 5 个空间使用者
R.LargestSpaceConsumers前 5 个空间使用量最大的使用者
R.LegendConsumed已使用
R.FileSizeBegin文件大小开始
R.FileSizeEnd文件大小结束

Source Code:

<Report ID="Microsoft.SQLServer.Windows.Views.Report.DBFilesForecast" Accessibility="Internal" Visible="true">

  <Dependencies>

    <DataWarehouseScript>Microsoft.SQLServer.Windows.Views.Script.GetDBFilesForecastData</DataWarehouseScript>

    <DataWarehouseScript>DWReport!Microsoft.SystemCenter.DataWarehouse.Report.Script.ObjectListParse</DataWarehouseScript>

    <ReportParameterControl>DWReport!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDateTimePicker</ReportParameterControl>

    <ReportParameterControl>DWReport!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.MonitoringObjectXmlPicker</ReportParameterControl>

    <ReportParameterControl>DWReport!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.NumericUpDown</ReportParameterControl>

  </Dependencies>

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

    <Controls>

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

        <ReportParameters>

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

            <Prompt>Microsoft.SQLServer.Windows.Views!Microsoft.SQLServer.Windows.Views.Report.DBFilesForecast.TimeZone</Prompt>

          </ReportParameter>

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

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

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

            <Prompt>Microsoft.SQLServer.Windows.Views!Microsoft.SQLServer.Windows.Views.Report.DBFilesForecast.StartDate</Prompt>

          </ReportParameter>

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

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

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

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

            <Prompt>Microsoft.SQLServer.Windows.Views!Microsoft.SQLServer.Windows.Views.Report.DBFilesForecast.EndDate</Prompt>

          </ReportParameter>

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

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

        </ReportParameters>

      </Control>

      <Control columnSpan="2" rowSpan="3" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.MonitoringObjectXmlPicker">

        <ReportParameters>

          <ReportParameter name="Objects">

            <Prompt>Microsoft.SQLServer.Windows.Views!Microsoft.SQLServer.Windows.Views.Report.DBFilesForecast.Scope</Prompt>

          </ReportParameter>

          <ReportParameter name="ManagementGroupId" binding="GroupList"/>

        </ReportParameters>

      </Control>

      <Control columnSpan="1" rowSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.NumericUpDown">

        <ReportParameters>

          <ReportParameter name="ForecastDays">

            <Prompt>Microsoft.SQLServer.Windows.Views!Microsoft.SQLServer.Windows.Views.Report.DBFilesForecast.ForecastDays</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="Minimum">

            <Value>0</Value>

          </Property>

          <Property name="Maximum">

            <Value>700</Value>

          </Property>

        </Properties>

      </Control>

    </Controls>

  </ParameterBlock>

  <ReportDefinition>Microsoft.SQLServer.Windows.Views.Report.DBFilesForecast.rdl</ReportDefinition>

  <ReportStrings>

    <ReportString ID="R.ManagementGroupComputer"/>

    <ReportString ID="R.ManagementGroupComputerInstance"/>

    <ReportString ID="R.Consumer"/>

    <ReportString ID="R.ConsumptionForecastGB"/>

    <ReportString ID="R.FinalAvgFreeSpacePercent"/>

    <ReportString ID="R.FinalSizeGB"/>

    <ReportString ID="R.FinallyConsumedGB"/>

    <ReportString ID="R.GrowthGB"/>

    <ReportString ID="R.InitialAvgFreeSpacePercent"/>

    <ReportString ID="R.InitialSizeGB"/>

    <ReportString ID="R.InitiallyConsumedGB"/>

    <ReportString ID="R.InstanceName"/>

    <ReportString ID="R.SizeGB"/>

    <ReportString ID="R.SizeForecastGB"/>

    <ReportString ID="R.ReportTitle"/>

    <ReportString ID="R.Summary"/>

    <ReportString ID="R.MostGrowingSpaceConsumers"/>

    <ReportString ID="R.LargestSpaceConsumers"/>

    <ReportString ID="R.LegendConsumed"/>

    <ReportString ID="R.FileSizeBegin"/>

    <ReportString ID="R.FileSizeEnd"/>

  </ReportStrings>

</Report>