Home
  •  

MSSQL 2008: SQL 사용자 연결에 대한 학습 데이터 수집 모니터

Microsoft.SQLServer.2008.UserConnectionsCollectionLearning (Rule)

Knowledge Base article:

요약

SQL 사용자 연결 모니터에 대한 학습 데이터를 수집합니다.

재정의 가능한 매개 변수

이름

설명

기본값

사용

워크플로를 사용하거나 사용하지 않도록 설정합니다.

예

빈도(초)

워크플로를 실행하는 반복 시간 간격(초)입니다.

300

Element properties:

TargetMicrosoft.SQLServer.2008.DBEngine
CategoryPerformanceCollection
EnabledTrue
Instance Name$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:General Statistics
Counter NameUser Connections
Frequency300
Alert GenerateFalse
RemotableTrue

Member Modules:

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

Source Code:

<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>