SSRS 2012: WorkingSetMaximum (GB)

Microsoft.SQLServer.2012.ReportingServices.PerformanceRule.Instance.HighMemoryLimit (Rule)

规则将收集实例的 WorkingSetMaximum 设置的配置(GB)。

Knowledge Base article:

摘要

规则将收集实例的 WorkingSetMaximum 设置的配置(GB)。

外部

http://msdn.microsoft.com/zh-cn/library/ms159206.aspx 更详细地讨论了 Reporting Services 的内存设置

可替代参数

名称

说明

默认值

已启用

Enables or disables the workflow

1

生成警报

The recurring interval of time in seconds in which to run the workflow.

间隔(秒)

运行工作流的重复间隔时间(秒)。

 

同步时间

Specifies the time the workflow is allowed to run before being closed and marked as failed.

300

Element properties:

TargetMicrosoft.SQLServer.2012.ReportingServices.Instance
CategoryPerformanceCollection
EnabledTrue
Alert GenerateFalse
RemotableTrue

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2012.ReportingServices.DataSource.MappedInstancePerfomanceDataProvider Microsoft.SQLServer.2012.ReportingServices.RunAsProfile.Monitoring
Mapper ConditionDetection System.Performance.DataGenericMapper Default
WriteToDB WriteAction Microsoft.SystemCenter.CollectPerformanceData Microsoft.SQLServer.2012.ReportingServices.RunAsProfile.Monitoring
WriteToDW WriteAction Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData Microsoft.SQLServer.2012.ReportingServices.RunAsProfile.Monitoring

Source Code:

<Rule ID="Microsoft.SQLServer.2012.ReportingServices.PerformanceRule.Instance.HighMemoryLimit" Enabled="true" Target="SQLRS!Microsoft.SQLServer.2012.ReportingServices.Instance" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.2012.ReportingServices.DataSource.MappedInstancePerfomanceDataProvider" RunAs="SQLRS!Microsoft.SQLServer.2012.ReportingServices.RunAsProfile.Monitoring">
<ServiceName>$Target/Property[Type='SQLRS!Microsoft.SQLServer.2012.ReportingServices.Instance']/ServiceName$</ServiceName>
<InstallPath>$Target/Property[Type='SQLRS!Microsoft.SQLServer.2012.ReportingServices.Instance']/InstallPath$</InstallPath>
<PerformanceCounterClassName>ConfigFile</PerformanceCounterClassName>
<PerformanceCounterPropertyName>WorkingSetMaximum</PerformanceCounterPropertyName>
<DividerIfGreater>0</DividerIfGreater>
<Divider>1073741824</Divider>
<IntervalSeconds>900</IntervalSeconds>
<SyncTime/>
</DataSource>
</DataSources>
<ConditionDetection ID="Mapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">
<ObjectName>SQL RS Instance</ObjectName>
<CounterName>Working Set Maximum (GB)</CounterName>
<InstanceName/>
<Value>$Data/Property[@Name='WorkingSetMaximum']$</Value>
</ConditionDetection>
<WriteActions>
<WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData" RunAs="SQLRS!Microsoft.SQLServer.2012.ReportingServices.RunAsProfile.Monitoring"/>
<WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData" RunAs="SQLRS!Microsoft.SQLServer.2012.ReportingServices.RunAsProfile.Monitoring"/>
</WriteActions>
</Rule>