OleDb Query Performace Collection

QueryOleDbMonitor.OleDbQueryPerformaceCollection (Rule)

Description for the new rule

Element properties:

Target	OleDBQueryMonitoring
Category	PerformanceCollection
Enabled	True
Alert Generate	False
Remotable	True

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	OleDbQueryMonitorPerformanceCollection	OleDBQueryMonitoringRunAsProfile
WA	WriteAction	Microsoft.SystemCenter.CollectPerformanceData	Default
WADWH	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData	Default

Source Code:

<Rule ID="QueryOleDbMonitor.OleDbQueryPerformaceCollection" Target="Library!OleDBQueryMonitoring" Enabled="true" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Library!OleDbQueryMonitorPerformanceCollection" RunAs="Library!OleDBQueryMonitoringRunAsProfile">

      <IntervalSeconds>$Target/Property[Type='Library!OleDBQueryMonitoring']/IntervalSeconds$</IntervalSeconds>

      <SyncTime>$Target/Property[Type='Library!OleDBQueryMonitoring']/SyncTime$</SyncTime>

      <ConnectionString>Provider=SQLOLEDB;Data Source=$Target/Property[Type='Library!OleDBQueryMonitoring']/Instance$;Initial Catalog=$Target/Property[Type='Library!OleDBQueryMonitoring']/Database$;Integrated Security=SSPI</ConnectionString>

      <Query>$Target/Property[Type='Library!OleDBQueryMonitoring']/Query$</Query>

      <QueryName>$Target/Property[Type='Library!OleDBQueryMonitoring']/QueryName$</QueryName>

    </DataSource>

  </DataSources>

  <WriteActions>

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

    <WriteAction ID="WADWH" TypeID="DWH!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>

  </WriteActions>

</Rule>