Home
  •  

SSAS 2012: Current Connections

Microsoft.SQLServer.2012._MSAS11_Connection_Current_connections_15.0_minutes_5_Rule (Rule)

Knowledge Base article:

Summary

Current number of client connections established. This counter is polled every fifteen minutes.

Unlike most performance data collection rules, this rule requires administrator rights on the server in order for the data to be collected by the agent. As such, this rule is configured to leverage the "SQL Server Monitoring Account" Run As profile that is provided with the SQL. For systems where the default agent action account is not an administrator, you must configure the "SQL Server Monitoring Account" Run As profile accordingly to ensure this performance data is collected.

Note that SQL Server Analysis Services Windows service is not supported by any edition of SQL Server Express.

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.

900

Element properties:

TargetMicrosoft.SQLServer.2012.AnalysisServices
CategoryPerformanceCollection
EnabledTrue
Instance Name$Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Connection
Counter NameCurrent connections
Frequency900
Alert GenerateFalse
RemotableTrue
CommentMom2012ID='{51C1FE08-9E7C-454A-AFF0-C0927C522020}';MOM2012GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}

Member Modules:

ID Module Type TypeId RunAs 
_26538F5A_12EC_4481_BCA1_3013FC11A243_ DataSource System.Performance.DataProvider Microsoft.SQLServer.SQLProbeAccount
PerfMapper ConditionDetection System.Performance.DataGenericMapper Default
CollectPerfData WriteAction Microsoft.SystemCenter.CollectPerformanceData Default
CollectPerfDataWarehouse WriteAction Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData Default

Source Code:

<Rule ID="Microsoft.SQLServer.2012._MSAS11_Connection_Current_connections_15.0_minutes_5_Rule" Target="SQL2012Core!Microsoft.SQLServer.2012.AnalysisServices" Enabled="true" ConfirmDelivery="false" Comment="Mom2012ID='{51C1FE08-9E7C-454A-AFF0-C0927C522020}';MOM2012GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="_26538F5A_12EC_4481_BCA1_3013FC11A243_" Comment="{26538F5A-12EC-4481-BCA1-3013FC11A243}" TypeID="SystemPerf!System.Performance.DataProvider" RunAs="SQL!Microsoft.SQLServer.SQLProbeAccount">

      <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <CounterName>Current connections</CounterName>

      <ObjectName>$Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Connection</ObjectName>

      <Frequency>900</Frequency>

    </DataSource>

  </DataSources>

  <ConditionDetection ID="PerfMapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">

    <ObjectName>SQL Analysis Services:Connection</ObjectName>

    <CounterName>$Data/CounterName$</CounterName>

    <InstanceName>$Data/InstanceName$</InstanceName>

    <Value>$Data/Value$</Value>

  </ConditionDetection>

  <WriteActions>

    <WriteAction ID="CollectPerfData" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>

    <WriteAction ID="CollectPerfDataWarehouse" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>

  </WriteActions>

</Rule>