SQL Broker 效能報表
這份報表如何運作?
SQL Broker 效能報表會顯示包含下列效能項目的圖表:
中止的啟用工作總數 交易回復數目 每秒鐘收到的 SQL 數目 達到啟用工作限制 傳輸訊息片段 每秒鐘啟動的工作 傳輸每秒鐘收到的 I/O 數目 傳輸開啟連線計數 統計資料 - 每秒鐘加入佇列的訊息 每秒鐘達到啟用工作限制的數目 統計資料 - 每秒鐘加入佇列的傳輸訊息 傳輸每秒鐘傳送的 I/O 數目 每秒鐘收到的傳輸訊息片段 每秒鐘叫用的啟用預存程序 統計資料 - 每秒鐘傳送的 SQL
若提供的物件為以下類型時,此報表會找到資料:
SQL 資料庫引擎
搜尋包含該內容與 "SQL Database Engine" 的物件
報表會為每個所選的物件,顯示不同的圖表。資料的彙總單位該月份當中的每一天。
如何使用這份報表?
從報表空間執行時:
搜尋結果中的第二個資料行會顯示所顯示之物件的類型。請務必選取 «SQL Database Engine» 類型的物件。
從監視空間執行時:
選擇 "SQL Database Engine" 類型,建立狀態檢視或效能檢視。
提供哪些參數?
日期/時間選項:可選擇相對或固定的日期、時間範圍及時區。
物件:可新增物件以執行此報表
Base | Microsoft.SystemCenter.DataWarehouse.Report.Performance |
Target | Microsoft.SQLServer.2012.DBEngine |
Accessibility | Public |
Visible | True |
<LinkedReport ID="Report.SQLServer.2012.BrokerPerformance" Target="SQL2012Core!Microsoft.SQLServer.2012.DBEngine" 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.2012.BrokerPerformance.ChartTitle1" >
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Tasks_Aborted_sec__Total_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>112,33,85</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_Broker_Transaction_Rollbacks_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>34,68,155</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_SQL_RECEIVEs_sec_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>74,60,143</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Task_Limit_Reached__Total_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>72,147,102</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Message_Fragment_Sends_sec_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>120,116,66</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Tasks_Started_sec__Total_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>204,122,209</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Receive_I_Os_sec_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>128,161,155</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Open_Connection_Count_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>110,80,14</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_Enqueued_Messages_sec_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>136,172,20</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Task_Limit_Reached_sec__Total_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>24,117,14</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_Enqueued_Transport_Msgs_sec_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>223,44,207</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Send_I_Os_sec_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>44,111,84</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Message_Fragment_Receives_sec_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>110,150,69</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Stored_Procedures_Invoked_sec__Total_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>142,176,142</Color>
</Series>
<Series>
<Rule>$MPElement[Name="Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_SQL_SENDs_sec_15.0_minutes_5_Rule"]$</Rule>
<Scale>1</Scale>
<Type>Line</Type>
<Color>125,126,36</Color>
</Series>
</Chart>
</Data>
</Value>
</Property>
<Property name="ContextObjectBinding">
<Value>Containment</Value>
</Property>
<Property name="TypeFilter">
<Value>Microsoft.SQLServer.2012.DBEngine</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.BooleanPicker" columnSpan="2">
<ReportParameters>
<ReportParameter name="Enable3D">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.Chart3D</Prompt>
</ReportParameter>
</ReportParameters>
</Control>
</Controls>
</ParameterBlock>
<Parameters>
<Parameter Name="AggregationType">
<Value>0</Value>
</Parameter>
</Parameters>
</LinkedReport>