User connections by peak hours for Performance Analysis Report
How does this report work?
The SQL database space report displays several chart with these performance items:
DB Free Space Total (%)
DB Free Space Total (MB)
DB Allocated Space (MB)
The report finds data if the objects supplied are of type
SQL Database
Search for objects with contains and (e.g. “Instance 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 “SQL 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 for
Base | Microsoft.SystemCenter.DataWarehouse.Report.Performance |
Target | Microsoft.SQLServer.2014.Database |
Accessibility | Public |
Visible | True |
<LinkedReport ID="Report.SQLServer.2014.DatabaseSpace" Target="SQL2014Core!Microsoft.SQLServer.2014.Database" Accessibility="Public" Visible="true" Base="ReportLibrary!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="Report.SQLServer.2014.DatabaseSpace.ChartTitle1">
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2014.Database.DBSpaceFreePercent.Collection"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>255,31,31</Color>
</Series>
</Chart>
<Chart ObjectJoin="ChartPerObject" TitleString="Report.SQLServer.2014.DatabaseSpace.ChartTitle2">
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2014.Database.DBSize.Collection"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>0,0,0</Color>
</Series>
</Chart>
<Chart ObjectJoin="ChartPerObject" TitleString="Report.SQLServer.2014.DatabaseSpace.ChartTitle3">
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2014.Database.DBSpaceFree.Collection"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>63,63,255 </Color>
</Series>
</Chart>
</Data>
</Value>
</Property>
<Property name="ContextObjectBinding">
<Value>Containment</Value>
</Property>
<Property name="TypeFilter">
<Value>Microsoft.SQLServer.2014.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>