SqlServr Process - Working Set (Sample)

SqlServr_Process___Working_Set__Sample__1_3_Rule (Rule)

Knowledge Base article:

Management Pack
Summary
Working Set of SQL Server process
 
Causes
TBD
 
Resolutions
TBD
 
© 2001-2005 Microsoft, all rights reserved.

Element properties:

TargetMicrosoft.Office.LiveCommunicationsServer.2005.Microsoft_Office_Live_Communications_Server_2005_Archiving_SQL_Server_Installation
CategoryPerformanceCollection
EnabledTrue
Instance NameProcess
Counter NameWorking Set
Frequency900
Alert GenerateFalse
RemotableTrue
CommentMom2005ID='{61B5738A-1B2D-4BD8-AAB1-19A12492C969}';MOM2005ComputerGroupID={58F2F2C8-7B66-4111-964E-D0F5D42988AC}

Member Modules:

ID Module Type TypeId RunAs 
_EBA72511_DAA6_45AC_8468_F6E8EDE4C054_ 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="SqlServr_Process___Working_Set__Sample__1_3_Rule" Target="Microsoft.Office.LiveCommunicationsServer.2005.Microsoft_Office_Live_Communications_Server_2005_Archiving_SQL_Server_Installation" Enabled="true" ConfirmDelivery="false" Comment="Mom2005ID='{61B5738A-1B2D-4BD8-AAB1-19A12492C969}';MOM2005ComputerGroupID={58F2F2C8-7B66-4111-964E-D0F5D42988AC}">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="_EBA72511_DAA6_45AC_8468_F6E8EDE4C054_" Comment="{EBA72511-DAA6-45AC-8468-F6E8EDE4C054}" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.Performance.FilteredDataProvider">
<ComputerName>$Target/Host/Property[Type="WindowsLibrary!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>Working Set</CounterName>
<ObjectName>Process</ObjectName>
<InstanceName>sqlservr</InstanceName>
<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>