.Net CLR Data-Sql Client Connections

Microsoft.Office.Sharepoint.Server.2007.Net_CLR_Data_Sql_Client_Connections (Rule)

This rule uses the SqlClient: Current # pooled and nonpooled connections counter to count the current number of active SQL connections, pooled or not.

Knowledge Base article:

Summary

This rule uses the SqlClient: Current # pooled and nonpooled connections counter to count the current number of active SQL connections, pooled or not pooled.

Element properties:

Target	Microsoft.Office.Sharepoint.Server.2007.MOSS.Server
Category	PerformanceCollection
Enabled	False
Instance Name	.NET CLR Data
Counter Name	SqlClient: Current # pooled and nonpooled connections
Frequency	3600
Alert Generate	False
Remotable	True

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	System.Performance.OptimizedDataProvider	Default
CollectData	WriteAction	Microsoft.SystemCenter.CollectPerformanceData	Default
DataWarehousePublishData	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData	Default

Source Code:

<Rule ID="Microsoft.Office.Sharepoint.Server.2007.Net_CLR_Data_Sql_Client_Connections" Enabled="false" Target="Microsoft.Office.Sharepoint.Server.2007.MOSS.Server" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Performance!System.Performance.OptimizedDataProvider">

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

      <CounterName>SqlClient: Current # pooled and nonpooled connections</CounterName>

      <ObjectName>.NET CLR Data</ObjectName>

      <InstanceName/>

      <AllInstances>false</AllInstances>

      <Frequency>3600</Frequency>

      <Tolerance>10</Tolerance>

      <ToleranceType>Percentage</ToleranceType>

      <MaximumSampleSeparation>2</MaximumSampleSeparation>

    </DataSource>

  </DataSources>

  <WriteActions>

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

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

  </WriteActions>

</Rule>