Home
  •  

MSSQL 2008: Collect Learning Data for SQL User Connections Monitor

Microsoft.SQLServer.2008.UserConnectionsCollectionLearning (Rule)

Knowledge Base article:

Summary

Collects learning data for the SQL User Connection Monitor.

Overrideable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Frequency (seconds)

The recurring interval of time in seconds in which to run the workflow.

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>