Mesure de performance SMS 2003 : connexions SQL SMS

SMS_2003_Perf_Measure__SMS_SQL_Connections_9_Rule (Rule)

Knowledge Base article:

Récapitulatif

Nombre total d’utilisateurs connectés au système.

Element properties:

TargetMicrosoft.SMS.2003.Microsoft_SMS_2003_Site_Database_Servers_Installation
CategoryPerformanceCollection
EnabledFalse
Instance NameSQLServer:General Statistics
Counter NameUser Connections
Frequency900
Alert GenerateFalse
RemotableTrue
CommentMom2005ID='{3A28D38F-C52A-4D4B-B418-5F395438A424}';MOM2005ComputerGroupID={6E07E901-5EEF-4D43-ABC9-5A73BC9B072D}

Member Modules:

ID Module Type TypeId RunAs 
_EAB4232B_70B0_4DA4_A8F7_2494A0A7853A_ DataSource System.Mom.BackwardCompatibility.Performance.FilteredDataProvider Default
CollectPerfData WriteAction Microsoft.SystemCenter.CollectPerformanceData Default
CollectPerfDataWarehouse WriteAction Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData Default
GenerateAlert WriteAction System.Mom.BackwardCompatibility.AlertResponse Default

Source Code:

<Rule ID="SMS_2003_Perf_Measure__SMS_SQL_Connections_9_Rule" Target="Microsoft.SMS.2003.Microsoft_SMS_2003_Site_Database_Servers_Installation" Enabled="false" ConfirmDelivery="false" Comment="Mom2005ID='{3A28D38F-C52A-4D4B-B418-5F395438A424}';MOM2005ComputerGroupID={6E07E901-5EEF-4D43-ABC9-5A73BC9B072D}">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="_EAB4232B_70B0_4DA4_A8F7_2494A0A7853A_" Comment="{EAB4232B-70B0-4DA4-A8F7-2494A0A7853A}" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.Performance.FilteredDataProvider">
<ComputerName>$Target/Host/Property[Type="WindowsLibrary!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>User Connections</CounterName>
<ObjectName>SQLServer:General Statistics</ObjectName>
<Frequency>900</Frequency>
<Expression/>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="GenerateAlert" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.AlertResponse">
<AlertGeneration>
<GenerateAlert>false</GenerateAlert>
</AlertGeneration>
<InvokerType>1</InvokerType>
</WriteAction>
<WriteAction ID="CollectPerfData" TypeID="SystemCenterLibrary!Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="CollectPerfDataWarehouse" TypeID="DataWarehouseLibrary!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>