Home
  •  

MSSQL 2005: Collect Learning Data for SQL User Connections Monitor

Microsoft.SQLServer.2005.UserConnectionsCollectionLearning (Rule)

Collects learning data for the SQL User Connection Monitor.

Knowledge Base article:

Summary

Collects learning data for the SQL User Connection Monitor.

Element properties:

TargetMicrosoft.SQLServer.2005.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.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>