Home
  •  

MSSQL 2008 : Collecter les données d'apprentissage pour l'analyse des connexions utilisateur SQL

Microsoft.SQLServer.2008.UserConnectionsCollectionLearning (Rule)

Knowledge Base article:

Résumé

Collecte les données d'apprentissage pour l'analyse des connexions utilisateur SQL.

Paramètres remplaçables

Nom

Description

Valeur par défaut

Activé

Active ou désactive le flux de travail.

Oui

Fréquence (secondes)

L'intervalle de temps récurrent, en secondes, dans lequel exécuter le flux de travail.

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>