Выполняет сбор обучающих данных для монитора соединений пользователей SQL.
Имя | Описание | Значение по умолчанию |
Вкл. | Включает или отключает рабочий процесс. | Да |
Периодичность (с) | Интервал перед повторным запуском рабочего процесса (в секундах). | 300 |
Target | Microsoft.SQLServer.2008.DBEngine |
Category | PerformanceCollection |
Enabled | True |
Instance Name | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:General Statistics |
Counter Name | User Connections |
Frequency | 300 |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | System.Performance.DataProvider | Microsoft.SQLServer.SQLDefaultAccount |
CD | ConditionDetection | System.Performance.SignatureCreatorWithoutCompression | Default |
WA | WriteAction | Microsoft.SystemCenter.CollectSignature | Default |
<Rule ID="Microsoft.SQLServer.2008.UserConnectionsCollectionLearning" Enabled="true" Target="SQL2008Core!Microsoft.SQLServer.2008.DBEngine">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="SystemPerf!System.Performance.DataProvider" RunAs="SQL!Microsoft.SQLServer.SQLDefaultAccount">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>User Connections</CounterName>
<ObjectName>$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:General Statistics</ObjectName>
<InstanceName/>
<AllInstances>false</AllInstances>
<Frequency>300</Frequency>
</DataSource>
</DataSources>
<ConditionDetection ID="CD" TypeID="SystemPerf!System.Performance.SignatureCreatorWithoutCompression">
<SignatureID>{D56436DB-41F0-4958-A8F0-9BC941674B4B}</SignatureID>
<BusinessCycleLengthUnit>Week</BusinessCycleLengthUnit>
<BusinessCycleLengthInGivenUnit>1</BusinessCycleLengthInGivenUnit>
<EffectiveSamplingPeriodInSeconds>300</EffectiveSamplingPeriodInSeconds>
<Sensitivity>2.81</Sensitivity>
<LearningSettings>
<LearningType>Continuous</LearningType>
<Offset1>3</Offset1>
<Offset2>3</Offset2>
<Offset3>3</Offset3>
<LearningRate>2.3333333333333335</LearningRate>
</LearningSettings>
<SignatureCollectionSettings>
<DBUpdatePeriodInSeconds>300</DBUpdatePeriodInSeconds>
</SignatureCollectionSettings>
</ConditionDetection>
<WriteActions>
<WriteAction ID="WA" TypeID="SC!Microsoft.SystemCenter.CollectSignature"/>
</WriteActions>
</Rule>