Regra de coleta de desempenho de Expectativa(s) de Vida da Página do Mecanismo de Banco de Dados SQL 2008
Expectativa(s) de Vida da Página do Mecanismo de Banco de Dados SQL 2008
Número de segundos em que uma página permanecerá no pool de buffers sem referências.
Target | Microsoft.SQLServer.2008.DBEngine |
Category | PerformanceCollection |
Enabled | True |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.2008.DBEngine.PageLifeExpectancy.DataSourceMapped | Microsoft.SQLServer.SQLProbeAccount |
WriteToDB | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
WriteToDW | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.SQLServer.2008.DBEngine.PageLifeExpectancy.Collection" Enabled="true" Target="SQL2008Core!Microsoft.SQLServer.2008.DBEngine" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.2008.DBEngine.PageLifeExpectancy.DataSourceMapped" RunAs="SQL!Microsoft.SQLServer.SQLProbeAccount">
<IntervalSeconds>900</IntervalSeconds>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>