SQL Database space for Performance Analysis Report
How does this report work?
The SQL database space report displays several chart with these performance items:
ROWS Data Free Space Total (%)
ROWS Data Free Space Total (%)
ROWS Data Free Space Total (MB)
In-Memory OLTP Data Disk Used Space (MB)
In-Memory OLTP Data Disk Free Space (%)
FILESTREAM Data Used Space (MB)
FILESTREAM Data Free Space (%)
The report finds data if the objects supplied are of type "MSSQL on Windows: Database".
Search for objects with contains and (e.g. “Database 1")
The report displays for every selected object a separate chart. Data is aggregated to days of a month.
How to use this report?
When run from the Reporting space:
The second column in the search results shows of which type the displayed objects are. Make sure you select objects of type SQL Database.
When run from the Monitoring space:
Create a state view or performance view by choosing the “MSSQL on Windows: Database” type.
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.
Base | Microsoft.SystemCenter.DataWarehouse.Report.Performance |
Target | Microsoft.SQLServer.Windows.Database |
Accessibility | Public |
Visible | True |
<LinkedReport ID="Microsoft.SQLServer.Windows.Views.Report.DatabaseSpace" Target="SqlDiscW!Microsoft.SQLServer.Windows.Database" Accessibility="Public" Visible="true" Base="DWReport!Microsoft.SystemCenter.DataWarehouse.Report.Performance">
<ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="6">
<Controls>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.ComboBox" columnSpan="2">
<ReportParameters>
<ReportParameter name="DataAggregation">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.DataAggregation</Prompt>
</ReportParameter>
</ReportParameters>
</Control>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.LinkedPerformanceChartObjectPicker" columnSpan="4" rowSpan="3">
<ReportParameters>
<ReportParameter name="ObjectList">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.ObjectList</Prompt>
</ReportParameter>
<ReportParameter name="ManagementGroupId" binding="GroupList"/>
</ReportParameters>
<Properties>
<Property name="ValueTemplate">
<Value>
<Data>
<Chart ObjectJoin="ChartPerObject" TitleString="Microsoft.SQLServer.Windows.Views.Report.DatabaseSpace.ChartTitle1">
<Series>
<Rule>$MPElement[Name="SqlMonW!Microsoft.SQLServer.Windows.CollectionRule.Database.RowsSpaceFreePercent"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>255,31,31</Color>
</Series>
</Chart>
<Chart ObjectJoin="ChartPerObject" TitleString="Microsoft.SQLServer.Windows.Views.Report.DatabaseSpace.ChartTitle2">
<Series>
<Rule>$MPElement[Name="SqlMonW!Microsoft.SQLServer.Windows.CollectionRule.Database.RowsSize"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>0,0,0</Color>
</Series>
</Chart>
<Chart ObjectJoin="ChartPerObject" TitleString="Microsoft.SQLServer.Windows.Views.Report.DatabaseSpace.ChartTitle3">
<Series>
<Rule>$MPElement[Name="SqlMonW!Microsoft.SQLServer.Windows.CollectionRule.Database.RowsSpaceFree"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>63,63,255</Color>
</Series>
</Chart>
<Chart ObjectJoin="ChartPerObject" TitleString="Microsoft.SQLServer.Windows.Views.Report.DatabaseSpace.ChartTitle4">
<Series>
<Rule>$MPElement[Name="SqlMonW!Microsoft.SQLServer.Windows.CollectionRule.Database.InMemoryOltpDiskSize"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>112,33,85</Color>
</Series>
</Chart>
<Chart ObjectJoin="ChartPerObject" TitleString="Microsoft.SQLServer.Windows.Views.Report.DatabaseSpace.ChartTitle5">
<Series>
<Rule>$MPElement[Name="SqlMonW!Microsoft.SQLServer.Windows.CollectionRule.Database.InMemoryOltpDiskSpaceFreePercent"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>34,68,155</Color>
</Series>
</Chart>
<Chart ObjectJoin="ChartPerObject" TitleString="Microsoft.SQLServer.Windows.Views.Report.DatabaseSpace.ChartTitle6">
<Series>
<Rule>$MPElement[Name="SqlMonW!Microsoft.SQLServer.Windows.CollectionRule.Database.FilestreamSize"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>74,60,143</Color>
</Series>
</Chart>
<Chart ObjectJoin="ChartPerObject" TitleString="Microsoft.SQLServer.Windows.Views.Report.DatabaseSpace.ChartTitle7">
<Series>
<Rule>$MPElement[Name="SqlMonW!Microsoft.SQLServer.Windows.CollectionRule.Database.FilestreamSpaceFreePercent"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>72,147,102</Color>
</Series>
</Chart>
</Data>
</Value>
</Property>
<Property name="ContextObjectBinding">
<Value>Containment</Value>
</Property>
<Property name="TypeFilter">
<Value>Microsoft.SQLServer.Windows.Database</Value>
</Property>
</Properties>
</Control>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.BusinessRelativeDateTimePicker" columnSpan="2">
<ReportParameters>
<ReportParameter name="TimeZone" binding="TimeZone">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.TimeZone</Prompt>
</ReportParameter>
<ReportParameter name="TimeZoneName" binding="TimeZoneName"/>
<ReportParameter name="StartDate_BaseType" binding="StartDate_BaseType"/>
<ReportParameter name="StartDate_BaseValue" binding="StartDate_BaseValue">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.StartDateTime</Prompt>
</ReportParameter>
<ReportParameter name="StartDate_OffsetType" binding="StartDate_OffsetType"/>
<ReportParameter name="StartDate_OffsetValue" binding="StartDate_OffsetValue"/>
<ReportParameter name="EndDate_BaseType" binding="EndDate_BaseType"/>
<ReportParameter name="EndDate_BaseValue" binding="EndDate_BaseValue">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.EndDateTime</Prompt>
</ReportParameter>
<ReportParameter name="EndDate_OffsetType" binding="EndDate_OffsetType"/>
<ReportParameter name="EndDate_OffsetValue" binding="EndDate_OffsetValue"/>
<ReportParameter name="TimeType" binding="TimeType"/>
<ReportParameter name="TimeWeekMap" binding="TimeWeekMap"/>
</ReportParameters>
</Control>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.ComboBox">
<ReportParameters>
<ReportParameter name="AggregationType">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.Histogram</Prompt>
</ReportParameter>
</ReportParameters>
</Control>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.BooleanPicker">
<ReportParameters>
<ReportParameter name="Enable3D">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.Chart3D</Prompt>
</ReportParameter>
</ReportParameters>
</Control>
</Controls>
</ParameterBlock>
</LinkedReport>