Database Files Space Usage Forecast

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

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 finds data if the objects supplied are of type "MSSQL on Windows: DB Engine".

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.

What Parameters are offered?

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

Object: Allows adding objects to run this report.

Element properties:

AccessibilityInternal
VisibleTrue

Report Localization:

R.ManagementGroupComputerManagement Group: ##(MG_NAME)## Computer: ##(COMP_NAME)##
R.ManagementGroupComputerInstanceManagement Group: ##(MG_NAME)## Computer: ##(COMP_NAME)## Instance: ##(INST_NAME)##
R.ConsumerConsumer
R.ConsumptionForecastGBConsumption forecast (GB)
R.FinalAvgFreeSpacePercentFinal average free space (\%)
R.FinalSizeGBFinal size (GB)
R.FinallyConsumedGBFinally consumed (GB)
R.GrowthGBGrowth (GB)
R.InitialAvgFreeSpacePercentInitial average free space (\%)
R.InitialSizeGBInitial size (GB)
R.InitiallyConsumedGBInitially consumed (GB)
R.InstanceNameInstance
R.SizeGBSize (GB)
R.SizeForecastGBSize forecast (GB)
R.ReportTitleDatabase Files Space Usage Forecast
R.SummarySummary
R.MostGrowingSpaceConsumers5 Most growing space consumers
R.LargestSpaceConsumers5 Largest space consumers
R.LegendConsumedConsumed
R.FileSizeBeginFile Size Begin
R.FileSizeEndFile Size End

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>