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.MostGrowingSpaceConsumers5 증가하는 주요 공간 소비자
R.LargestSpaceConsumers5 최대 공간 소비자
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>