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>