The rule collects the value of WorkingSetMinimum setting in gigabytes for the given SSRS Instance.
The rule collects the value of WorkingSetMinimum setting in gigabytes for the given SSRS Instance.
http://msdn.microsoft.com/en-us/library/ms159206.aspx talks more about the memory settings for Reporting services
Name | Description | Default Value |
Enabled |
| 1 |
Generates Alerts |
| No |
Interval (seconds) | The recurring interval of time in seconds in which to run the workflow. | 900 |
Synchronization Time |
|
|
Target | Microsoft.SQLServer.2012.ReportingServices.Instance |
Category | PerformanceCollection |
Enabled | True |
Alert Generate | False |
Remotable | True |
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 |
<Rule ID="Microsoft.SQLServer.2012.ReportingServices.PerformanceRule.Instance.LowMemoryLimit" 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>WorkingSetMinimum</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 Minimum (GB)</CounterName>
<InstanceName/>
<Value>$Data/Property[@Name='WorkingSetMinimum']$</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>