Database Files Space Usage Forecast
How does this report work?
The Database Files Space Usage Forecast report displays several charts with the following performance items:
Initially consumed file space (GB)
Finally consumed file space (GB)
Initial average free file space (%)
Final average free file space (%)
File space consumption forecast (GB)
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.
Accessibility | Internal |
Visible | True |
R.ManagementGroupComputer | Группа управления: ##(MG_NAME)## Компьютер: ##(COMP_NAME)## | |
R.ManagementGroupComputerInstance | Группа управления: ##(MG_NAME)## Компьютер: ##(COMP_NAME)## Экземпляр: ##(INST_NAME)## | |
R.Consumer | Потребитель | |
R.ConsumptionForecastGB | Прогноз потребления (ГБ) | |
R.FinalAvgFreeSpacePercent | Окончательное среднее значение свободного места (\%) | |
R.FinalSizeGB | Окончательный размер (ГБ) | |
R.FinallyConsumedGB | Окончательно потреблено (ГБ) | |
R.GrowthGB | Увеличение (ГБ) | |
R.InitialAvgFreeSpacePercent | Начальное среднее значение свободного места (\%) | |
R.InitialSizeGB | Начальный размер (ГБ) | |
R.InitiallyConsumedGB | Изначально потреблено (ГБ) | |
R.InstanceName | Экземпляр | |
R.SizeGB | Размер (ГБ) | |
R.SizeForecastGB | Прогноз размера (ГБ) | |
R.ReportTitle | Прогноз использования пространства файлов базы данных | |
R.Summary | Сводка | |
R.MostGrowingSpaceConsumers | Пять потребителей, больше всего увеличивших пространство | |
R.LargestSpaceConsumers | Пять потребителей с наибольшим пространством | |
R.LegendConsumed | Израсходовано | |
R.FileSizeBegin | Начальный размер файла | |
R.FileSizeEnd | Конечный размер файла |
<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>