SQL 사용자 연결 모니터에 대한 학습 데이터를 수집합니다.
SQL 사용자 연결 모니터에 대한 학습 데이터를 수집합니다.
이름 | 설명 | 기본값 |
사용 | 워크플로를 사용하거나 사용하지 않도록 설정합니다. | 예 |
빈도(초) | 워크플로를 실행하는 반복 시간 간격(초)입니다. | 300 |
Target | Microsoft.SQLServer.2005.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.2005.UserConnectionsCollectionLearning" Enabled="true" Target="SQL2005Core!Microsoft.SQLServer.2005.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>