Ce modèle vous permet d'analyser une source de données compatible OLE DB. Vous pouvez choisir dans une liste de fournisseurs OLE DB ou fournir une chaîne de connexion pour analyser la source de données cible.
Source Code:
<Template ID="Microsoft.SystemCenter.SyntheticTransactions.OleDbCheck.Template">
<Configuration>
<IncludeSchemaTypes>
<SchemaType>SC!Microsoft.SystemCenter.GroupPopulationSchema</SchemaType>
</IncludeSchemaTypes>
<xsd:element name="TypeId" type="xsd:string"/>
<xsd:element name="Name" type="xsd:string"/>
<xsd:element name="Description" type="xsd:string"/>
<xsd:element name="LocaleId" type="xsd:string"/>
<xsd:element name="ConnectionString" type="xsd:string"/>
<xsd:element name="PollIntervalInSeconds" type="xsd:unsignedInt"/>
<xsd:element name="IncludeList" type="MonitoringObjectIdListType"/>
<xsd:element name="WatcherComputersList" type="xsd:string"/>
<xsd:element name="UniquenessKey" type="xsd:string"/>
<xsd:element name="Query" type="xsd:string" minOccurs="0" maxOccurs="1"/>
<xsd:element name="QueryTimeout" type="xsd:integer" minOccurs="0" maxOccurs="1"/>
<xsd:element name="HasQuery" type="xsd:boolean"/>
<xsd:element name="EnableConnectionTimeMonitor" type="xsd:boolean"/>
<xsd:element name="EnableQueryExecutionTimeMonitor" type="xsd:boolean"/>
<xsd:element name="EnableQueryFetchTimeMonitor" type="xsd:boolean"/>
<xsd:element name="ConnectionTimeWarningThreshold" type="xsd:unsignedInt" minOccurs="0" maxOccurs="1"/>
<xsd:element name="ConnectionTimeErrorThreshold" type="xsd:unsignedInt" minOccurs="0" maxOccurs="1"/>
<xsd:element name="QueryExecutionTimeWarningThreshold" type="xsd:unsignedInt" minOccurs="0" maxOccurs="1"/>
<xsd:element name="QueryExecutionTimeErrorThreshold" type="xsd:unsignedInt" minOccurs="0" maxOccurs="1"/>
<xsd:element name="QueryFetchTimeWarningThreshold" type="xsd:unsignedInt" minOccurs="0" maxOccurs="1"/>
<xsd:element name="QueryFetchTimeErrorThreshold" type="xsd:string" minOccurs="0" maxOccurs="1"/>
</Configuration>
<References>
<Reference ID="System"/>
<Reference ID="SC"/>
<Reference ID="SCDW"/>
<Reference ID="Windows"/>
<Reference ID="Self"/>
<Reference ID="Performance"/>
<Reference ID="Health"/>
</References>
<Implementation>
<TypeDefinitions>
<EntityTypes>
<ClassTypes>
<ClassType ID="$TemplateConfig/TypeId$" Base="$Reference/Self$Microsoft.SystemCenter.SyntheticTransactions.OleDbCheckPerspective" Abstract="false" Accessibility="Public" Hosted="true"/>
<ClassType ID="$TemplateConfig/TypeId$Group" Base="$Reference/Self$Microsoft.SystemCenter.SyntheticTransactions.OleDbCheckPerspectiveGroup" Abstract="false" Accessibility="Public" Singleton="true" Hosted="false"/>
<ClassType ID="$TemplateConfig/TypeId$WatcherComputersGroup" Abstract="false" Accessibility="Public" Base="$Reference/SC$Microsoft.SystemCenter.ComputerGroup" Hosted="false" Singleton="true"/>
</ClassTypes>
<RelationshipTypes>
<RelationshipType ID="$TemplateConfig/TypeId$Group.Contains.$TemplateConfig/TypeId$" Accessibility="Public" Base="$Reference/System$System.Containment">
<Source>$TemplateConfig/TypeId$Group</Source>
<Target>$TemplateConfig/TypeId$</Target>
</RelationshipType>
</RelationshipTypes>
</EntityTypes>
<SecureReferences>
<SecureReference ID="$TemplateConfig/TypeId$.PrivilegedMonitoringAccount" Accessibility="Public" Context="$Reference/System$System.Entity"/>
<SecureReference ID="$TemplateConfig/TypeId$.SimpleAuthenticationAccount" Accessibility="Public" Context="$Reference/System$System.Entity"/>
</SecureReferences>
<ModuleTypes>
<DataSourceModuleType ID="$TemplateConfig/TypeId$.OleDbDataSource" Accessibility="Public" RunAs="$TemplateConfig/TypeId$.PrivilegedMonitoringAccount">
<Configuration/>
<ModuleImplementation>
<Composite>
<MemberModules>
<DataSource TypeID="$Reference/System$System.Scheduler" ID="Scheduler">
<Scheduler>
<SimpleReccuringSchedule>
<Interval Unit="Seconds">$TemplateConfig/PollIntervalInSeconds$</Interval>
</SimpleReccuringSchedule>
<ExcludeDates/>
</Scheduler>
</DataSource>
<ProbeAction TypeID="$Reference/System$System.OleDbProbe" ID="Probe">
<ConnectionString>$TemplateConfig/ConnectionString$</ConnectionString>
<Query>$TemplateConfig/Query$</Query>
<GetValue>false</GetValue>
<QueryTimeout>$TemplateConfig/QueryTimeout$</QueryTimeout>
<GetFetchTime>true</GetFetchTime>
</ProbeAction>
</MemberModules>
<Composition>
<Node ID="Probe">
<Node ID="Scheduler"/>
</Node>
</Composition>
</Composite>
</ModuleImplementation>
<OutputType>$Reference/System$System.OleDbData</OutputType>
</DataSourceModuleType>
</ModuleTypes>
<MonitorTypes>
<UnitMonitorType ID="$TemplateConfig/TypeId$.NoConnection" Accessibility="Public">
<MonitorTypeStates>
<MonitorTypeState ID="ConnectionFailure"/>
<MonitorTypeState ID="NoConnectionFailure"/>
</MonitorTypeStates>
<Configuration/>
<MonitorImplementation>
<MemberModules>
<DataSource TypeID="$TemplateConfig/TypeId$.OleDbDataSource" ID="DS"/>
<ConditionDetection TypeID="$Reference/System$System.ExpressionFilter" ID="CDFailed">
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">HRResult</XPathQuery>
</ValueExpression>
<Operator>Less</Operator>
<ValueExpression>
<Value Type="Integer">0</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</ConditionDetection>
<ConditionDetection TypeID="$Reference/System$System.ExpressionFilter" ID="CDPassed">
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">HRResult</XPathQuery>
</ValueExpression>
<Operator>GreaterEqual</Operator>
<ValueExpression>
<Value Type="Integer">0</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</ConditionDetection>
</MemberModules>
<RegularDetections>
<RegularDetection MonitorTypeStateID="ConnectionFailure">
<Node ID="CDFailed">
<Node ID="DS"/>
</Node>
</RegularDetection>
<RegularDetection MonitorTypeStateID="NoConnectionFailure">
<Node ID="CDPassed">
<Node ID="DS"/>
</Node>
</RegularDetection>
</RegularDetections>
</MonitorImplementation>
</UnitMonitorType>
<UnitMonitorType ID="$TemplateConfig/TypeId$.OleDbPerformanceCounter" Accessibility="Public">
<MonitorTypeStates>
<MonitorTypeState ID="UnderThreshold1"/>
<MonitorTypeState ID="OverThreshold1UnderThreshold2"/>
<MonitorTypeState ID="OverThreshold2"/>
</MonitorTypeStates>
<Configuration>
<xsd:element name="CounterName" type="xsd:string"/>
<xsd:element name="Threshold1" type="xsd:unsignedInt"/>
<xsd:element name="Threshold2" type="xsd:unsignedInt"/>
</Configuration>
<OverrideableParameters>
<OverrideableParameter ID="Threshold1" ParameterType="int" Selector="$Config/Threshold1$"/>
<OverrideableParameter ID="Threshold2" ParameterType="int" Selector="$Config/Threshold2$"/>
</OverrideableParameters>
<MonitorImplementation>
<MemberModules>
<DataSource TypeID="$TemplateConfig/TypeId$.OleDbDataSource" ID="DS"/>
<ConditionDetection TypeID="$Reference/System$System.ExpressionFilter" ID="CDUnderThreshold1">
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="UnsignedInteger">$Config/CounterName$</XPathQuery>
</ValueExpression>
<Operator>Less</Operator>
<ValueExpression>
<Value Type="UnsignedInteger">$Config/Threshold1$</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</ConditionDetection>
<ConditionDetection TypeID="$Reference/System$System.ExpressionFilter" ID="CDOverThreshold1UnderThreshold2">
<Expression>
<And>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="UnsignedInteger">$Config/CounterName$</XPathQuery>
</ValueExpression>
<Operator>GreaterEqual</Operator>
<ValueExpression>
<Value Type="UnsignedInteger">$Config/Threshold1$</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="UnsignedInteger">$Config/CounterName$</XPathQuery>
</ValueExpression>
<Operator>LessEqual</Operator>
<ValueExpression>
<Value Type="UnsignedInteger">$Config/Threshold2$</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</And>
</Expression>
</ConditionDetection>
<ConditionDetection TypeID="$Reference/System$System.ExpressionFilter" ID="CDOverThreshold2">
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="UnsignedInteger">$Config/CounterName$</XPathQuery>
</ValueExpression>
<Operator>Greater</Operator>
<ValueExpression>
<Value Type="UnsignedInteger">$Config/Threshold2$</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</ConditionDetection>
</MemberModules>
<RegularDetections>
<RegularDetection MonitorTypeStateID="UnderThreshold1">
<Node ID="CDUnderThreshold1">
<Node ID="DS"/>
</Node>
</RegularDetection>
<RegularDetection MonitorTypeStateID="OverThreshold1UnderThreshold2">
<Node ID="CDOverThreshold1UnderThreshold2">
<Node ID="DS"/>
</Node>
</RegularDetection>
<RegularDetection MonitorTypeStateID="OverThreshold2">
<Node ID="CDOverThreshold2">
<Node ID="DS"/>
</Node>
</RegularDetection>
</RegularDetections>
</MonitorImplementation>
</UnitMonitorType>
</MonitorTypes>
</TypeDefinitions>
<Monitoring>
<Discoveries>
<Discovery ID="$TemplateConfig/TypeId$.Discovery.Rule" Enabled="false" Target="$Reference/Windows$Microsoft.Windows.Computer">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="$TemplateConfig/TypeId$"/>
<DiscoveryRelationship TypeID="$Reference/Self$Microsoft.SystemCenter.SyntheticTransactions.ComputerHostsOleDbCheckPerspective"/>
</DiscoveryTypes>
<DataSource ID="PerspectiveDiscoveryDS" TypeID="$Reference/Self$Microsoft.SystemCenter.SyntheticTransactions.PerspectiveDiscoveryDataSource">
<ClassId>$MPElement[Name="$TemplateConfig/TypeId$"]$</ClassId>
<DisplayName>$TemplateConfig/Name$</DisplayName>
<WatcherComputersList>$TemplateConfig/WatcherComputersList$</WatcherComputersList>
<UniquenessKey>$TemplateConfig/UniquenessKey$</UniquenessKey>
</DataSource>
</Discovery>
<Discovery ID="$TemplateConfig/TypeId$Group.Discovery.Rule" Enabled="true" Target="$TemplateConfig/TypeId$Group">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="$TemplateConfig/TypeId$Group"/>
</DiscoveryTypes>
<DataSource ID="GroupDiscoveryDS" TypeID="$Reference/SC$Microsoft.SystemCenter.GroupPopulator">
<RuleId>$MPElement$</RuleId>
<GroupInstanceId>$Target/Id$</GroupInstanceId>
<MembershipRules>
<MembershipRule>
<MonitoringClass>$MPElement[Name="$TemplateConfig/TypeId$"]$</MonitoringClass>
<RelationshipClass>$MPElement[Name="$TemplateConfig/TypeId$Group.Contains.$TemplateConfig/TypeId$"]$</RelationshipClass>
</MembershipRule>
</MembershipRules>
</DataSource>
</Discovery>
<Discovery ID="$TemplateConfig/TypeId$WatcherComputersGroup.Discovery.Rule" Target="$TemplateConfig/TypeId$WatcherComputersGroup" Enabled="true">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="$TemplateConfig/TypeId$WatcherComputersGroup"/>
</DiscoveryTypes>
<DataSource ID="GroupPopulationDataSource" TypeID="$Reference/SC$Microsoft.SystemCenter.GroupPopulator">
<RuleId>$MPElement$</RuleId>
<GroupInstanceId>$Target/Id$</GroupInstanceId>
<MembershipRules>
<MembershipRule>
<MonitoringClass>$MPElement[Name="$Reference/Windows$Microsoft.Windows.Computer"]$</MonitoringClass>
<RelationshipClass>$MPElement[Name="$Reference/SC$Microsoft.SystemCenter.ComputerGroupContainsComputer"]$</RelationshipClass>
<IncludeList>$TemplateConfig/IncludeList$</IncludeList>
</MembershipRule>
<MembershipRule>
<MonitoringClass>$MPElement[Name="$Reference/Windows$Microsoft.Windows.Computer"]$</MonitoringClass>
<RelationshipClass>$MPElement[Name="$Reference/SC$Microsoft.SystemCenter.ComputerGroupContainsComputer"]$</RelationshipClass>
<Expression>
<Contains maxDepth="1">
<MonitoringClass>$MPElement[Name="$TemplateConfig/TypeId$"]$</MonitoringClass>
</Contains>
</Expression>
</MembershipRule>
</MembershipRules>
</DataSource>
</Discovery>
</Discoveries>
<Rules>
<Rule ID="$TemplateConfig/TypeId$.InitTime" Target="$TemplateConfig/TypeId$" Enabled="true">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource TypeID="$TemplateConfig/TypeId$.OleDbDataSource" ID="DS"/>
</DataSources>
<ConditionDetection TypeID="$Reference/Performance$System.Performance.DataGenericMapper" ID="PerfMapper">
<ObjectName>Ole Db Check</ObjectName>
<CounterName>Connection Time</CounterName>
<InstanceName>$TemplateConfig/Name$</InstanceName>
<Value>$Data/InitializationTime$</Value>
</ConditionDetection>
<WriteActions>
<WriteAction ID="PerfWriteAction" TypeID="$Reference/SC$Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="PerfWriteToDWAction" TypeID="$Reference/SCDW$Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>
<Rule ID="$TemplateConfig/TypeId$.QueryExecutionTime" Target="$TemplateConfig/TypeId$" Enabled="$TemplateConfig/HasQuery$">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource TypeID="$TemplateConfig/TypeId$.OleDbDataSource" ID="DS"/>
</DataSources>
<ConditionDetection TypeID="$Reference/Performance$System.Performance.DataGenericMapper" ID="PerfMapper">
<ObjectName>Ole Db Check</ObjectName>
<CounterName>Execution Time</CounterName>
<InstanceName>$TemplateConfig/Name$</InstanceName>
<Value>$Data/ExecutionTime$</Value>
</ConditionDetection>
<WriteActions>
<WriteAction ID="PerfWriteAction" TypeID="$Reference/SC$Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="PerfWriteToDWAction" TypeID="$Reference/SCDW$Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>
<Rule ID="$TemplateConfig/TypeId$.QueryFetchTime" Target="$TemplateConfig/TypeId$" Enabled="$TemplateConfig/HasQuery$">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource TypeID="$TemplateConfig/TypeId$.OleDbDataSource" ID="DS"/>
</DataSources>
<ConditionDetection TypeID="$Reference/Performance$System.Performance.DataGenericMapper" ID="PerfMapper">
<ObjectName>Ole Db Check</ObjectName>
<CounterName>Fetch Time</CounterName>
<InstanceName>$TemplateConfig/Name$</InstanceName>
<Value>$Data/FetchTime$</Value>
</ConditionDetection>
<WriteActions>
<WriteAction ID="PerfWriteAction" TypeID="$Reference/SC$Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="PerfWriteToDWAction" TypeID="$Reference/SCDW$Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>
</Rules>
<Monitors>
<UnitMonitor ID="$TemplateConfig/TypeId$.NoConnectionMonitor" TypeID="$TemplateConfig/TypeId$.NoConnection" Target="$TemplateConfig/TypeId$" ParentMonitorID="$Reference/Health$System.Health.AvailabilityState" Enabled="true" Accessibility="Public">
<Category>AvailabilityHealth</Category>
<AlertSettings AlertMessage="$TemplateConfig/TypeId$.GroupHealth.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertParameters>
<AlertParameter1>$Data/Context/ResultCode$</AlertParameter1>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="OK" MonitorTypeStateID="NoConnectionFailure" HealthState="Success"/>
<OperationalState ID="Error" MonitorTypeStateID="ConnectionFailure" HealthState="Error"/>
</OperationalStates>
<Configuration/>
</UnitMonitor>
<UnitMonitor ID="$TemplateConfig/TypeId$.ConnectionTimeMonitor" TypeID="$TemplateConfig/TypeId$.OleDbPerformanceCounter" Target="$TemplateConfig/TypeId$" ParentMonitorID="$Reference/Health$System.Health.PerformanceState" Enabled="$TemplateConfig/EnableConnectionTimeMonitor$" Accessibility="Public">
<Category>PerformanceHealth</Category>
<AlertSettings AlertMessage="$TemplateConfig/TypeId$.ConnectionTimeMonitor.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertParameters>
<AlertParameter1>$Data/Context/InitializationTime$</AlertParameter1>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="OK" MonitorTypeStateID="UnderThreshold1" HealthState="Success"/>
<OperationalState ID="Warning" MonitorTypeStateID="OverThreshold1UnderThreshold2" HealthState="Warning"/>
<OperationalState ID="Error" MonitorTypeStateID="OverThreshold2" HealthState="Error"/>
</OperationalStates>
<Configuration>
<CounterName>InitializationTime</CounterName>
<Threshold1>$TemplateConfig/ConnectionTimeWarningThreshold$</Threshold1>
<Threshold2>$TemplateConfig/ConnectionTimeErrorThreshold$</Threshold2>
</Configuration>
</UnitMonitor>
<UnitMonitor ID="$TemplateConfig/TypeId$.QueryExecutionTimeMonitor" TypeID="$TemplateConfig/TypeId$.OleDbPerformanceCounter" Target="$TemplateConfig/TypeId$" ParentMonitorID="$Reference/Health$System.Health.PerformanceState" Enabled="$TemplateConfig/EnableQueryExecutionTimeMonitor$" Accessibility="Public">
<Category>PerformanceHealth</Category>
<AlertSettings AlertMessage="$TemplateConfig/TypeId$.QueryExecutionTimeMonitor.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertParameters>
<AlertParameter1>$Data/Context/ExecutionTime$</AlertParameter1>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="OK" MonitorTypeStateID="UnderThreshold1" HealthState="Success"/>
<OperationalState ID="Warning" MonitorTypeStateID="OverThreshold1UnderThreshold2" HealthState="Warning"/>
<OperationalState ID="Error" MonitorTypeStateID="OverThreshold2" HealthState="Error"/>
</OperationalStates>
<Configuration>
<CounterName>ExecutionTime</CounterName>
<Threshold1>$TemplateConfig/QueryExecutionTimeWarningThreshold$</Threshold1>
<Threshold2>$TemplateConfig/QueryExecutionTimeErrorThreshold$</Threshold2>
</Configuration>
</UnitMonitor>
<UnitMonitor ID="$TemplateConfig/TypeId$.QueryFetchTimeMonitor" TypeID="$TemplateConfig/TypeId$.OleDbPerformanceCounter" Target="$TemplateConfig/TypeId$" ParentMonitorID="$Reference/Health$System.Health.PerformanceState" Enabled="$TemplateConfig/EnableQueryFetchTimeMonitor$" Accessibility="Public">
<Category>PerformanceHealth</Category>
<AlertSettings AlertMessage="$TemplateConfig/TypeId$.QueryFetchTimeMonitor.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertParameters>
<AlertParameter1>$Data/Context/FetchTime$</AlertParameter1>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="OK" MonitorTypeStateID="UnderThreshold1" HealthState="Success"/>
<OperationalState ID="Warning" MonitorTypeStateID="OverThreshold1UnderThreshold2" HealthState="Warning"/>
<OperationalState ID="Error" MonitorTypeStateID="OverThreshold2" HealthState="Error"/>
</OperationalStates>
<Configuration>
<CounterName>FetchTime</CounterName>
<Threshold1>$TemplateConfig/QueryFetchTimeWarningThreshold$</Threshold1>
<Threshold2>$TemplateConfig/QueryFetchTimeErrorThreshold$</Threshold2>
</Configuration>
</UnitMonitor>
<DependencyMonitor ID="$TemplateConfig/TypeId$.GroupHealth" Accessibility="Public" Target="$TemplateConfig/TypeId$Group" Enabled="true" ParentMonitorID="$Reference/Health$System.Health.AvailabilityState" RelationshipType="$TemplateConfig/TypeId$Group.Contains.$TemplateConfig/TypeId$" MemberMonitor="$Reference/Health$System.Health.AvailabilityState">
<Category>AvailabilityHealth</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Error</MemberUnAvailable>
</DependencyMonitor>
<DependencyMonitor ID="$TemplateConfig/TypeId$.GroupPerformanceHealth" Accessibility="Public" Target="$TemplateConfig/TypeId$Group" Enabled="true" ParentMonitorID="$Reference/Health$System.Health.PerformanceState" RelationshipType="$TemplateConfig/TypeId$Group.Contains.$TemplateConfig/TypeId$" MemberMonitor="$Reference/Health$System.Health.PerformanceState">
<Category>PerformanceHealth</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Error</MemberUnAvailable>
</DependencyMonitor>
</Monitors>
<Overrides>
<DiscoveryPropertyOverride ID="$TemplateConfig/TypeId$.Discovery.Rule.Override" Discovery="$TemplateConfig/TypeId$.Discovery.Rule" Context="$TemplateConfig/TypeId$WatcherComputersGroup" Enforced="false" Property="Enabled">
<Value>true</Value>
</DiscoveryPropertyOverride>
</Overrides>
</Monitoring>
<Presentation>
<StringResources>
<StringResource ID="$TemplateConfig/TypeId$.GroupHealth.AlertMessage"/>
<StringResource ID="$TemplateConfig/TypeId$.ConnectionTimeMonitor.AlertMessage"/>
<StringResource ID="$TemplateConfig/TypeId$.QueryExecutionTimeMonitor.AlertMessage"/>
<StringResource ID="$TemplateConfig/TypeId$.QueryFetchTimeMonitor.AlertMessage"/>
</StringResources>
</Presentation>
<LanguagePacks>
<LanguagePack ID="$TemplateConfig/LocaleId$">
<DisplayStrings>
<DisplayString ElementID="$TemplateConfig/TypeId$">
<Name>$TemplateConfig/Name$</Name>
<Description>$TemplateConfig/Description$</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.PrivilegedMonitoringAccount">
<Name>$TemplateConfig/Name$ OLE DB Synthetic Transaction Action Profile</Name>
<Description>This profile is used to monitor $TemplateConfig/Name$ OLE DB Data source for Integrated security.</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.SimpleAuthenticationAccount">
<Name>$TemplateConfig/Name$ OLE DB Simple Authentication Profile</Name>
<Description>If specified, this login name and password can be referenced in the connection string to connect to $TemplateConfig/Name$ for alternative authentication model.</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.Discovery.Rule">
<Name>$TemplateConfig/Name$ Discovery</Name>
<Description>Discovery rule for $TemplateConfig/Name$</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$Group.Discovery.Rule">
<Name>$TemplateConfig/Name$ Group Discovery</Name>
<Description>Discovery for group of $TemplateConfig/Name$</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$WatcherComputersGroup.Discovery.Rule">
<Name>$TemplateConfig/Name$ Watcher Group Discovery</Name>
<Description>Discovery for $TemplateConfig/Name$ watcher computers</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$Group.Contains.$TemplateConfig/TypeId$">
<Name>Group of $TemplateConfig/Name$</Name>
<Description>Group of $TemplateConfig/Name$</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$WatcherComputersGroup">
<Name>$TemplateConfig/Name$ watcher computers group</Name>
<Description>Group of $TemplateConfig/Name$ watcher computers</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.NoConnectionMonitor">
<Name>Data Source Status Monitor</Name>
<Description>Monitors for the OLE DB connection and query status</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.NoConnectionMonitor" SubElementID="OK">
<Name>Connection and/or Query succeeded</Name>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.NoConnectionMonitor" SubElementID="Error">
<Name>Connection and/or Query failed</Name>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.GroupHealth">
<Name>$TemplateConfig/Name$ Group Monitor</Name>
<Description>Monitors the $TemplateConfig/Name$ group</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.GroupHealth.AlertMessage">
<Name>$TemplateConfig/Name$ OLE DB status</Name>
<Description>The OLE DB Database Transaction experienced an error while connecting and/or executing the query. Status code : {0}. </Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$Group">
<Name>$TemplateConfig/Name$ OLE DB Check Group</Name>
<Description>Group of $TemplateConfig/Name$</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.InitTime">
<Name>$TemplateConfig/Name$ OLE DB Initialization Time Performance Collection</Name>
<Description>Collects performance counter for the initialization time of the OLE DB data source.</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.NoConnection">
<Name>OLE DB Connection Monitor</Name>
<Description>This monitor type detects if the target data source is reachable and if a connection can be established.</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.NoConnection" SubElementID="ConnectionFailure">
<Name>Connection Failure (Error)</Name>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.NoConnection" SubElementID="NoConnectionFailure">
<Name>Connection Completed (Success)</Name>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.GroupPerformanceHealth">
<Name>$TemplateConfig/Name$ Group Performance Monitor</Name>
<Description>Rollup Monitor for the performance of all the user perspectives in the $TemplateConfig/Name$ group</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.ConnectionTimeMonitor">
<Name>Connection Time Monitor</Name>
<Description>Monitors the amount of time taken to connect to the database. It changes state based on the thresholds configured for error and warning.</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.ConnectionTimeMonitor" SubElementID="OK">
<Name>Connection time is less than the lowest threshold</Name>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.ConnectionTimeMonitor" SubElementID="Warning">
<Name>Connection time is between upper threshold and lower threshold</Name>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.ConnectionTimeMonitor" SubElementID="Error">
<Name>Connection time has exceeded the upper threshold</Name>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.QueryExecutionTimeMonitor">
<Name>Execution Time Monitor</Name>
<Description>Monitors the amount of time taken to execute the query. It changes state based on the thresholds configured for error and warning.</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.QueryExecutionTimeMonitor" SubElementID="OK">
<Name>Execution time is less than the lowest threshold</Name>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.QueryExecutionTimeMonitor" SubElementID="Warning">
<Name>Execution time is between upper threshold and lower threshold</Name>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.QueryExecutionTimeMonitor" SubElementID="Error">
<Name>Execution time has exceeded the upper threshold</Name>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.QueryFetchTimeMonitor">
<Name>Fetch Time Monitor</Name>
<Description>Monitors the amount of time taken to fetch the results from the query. It changes state based on the thresholds configured for error and warning.</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.QueryFetchTimeMonitor" SubElementID="OK">
<Name>Fetch time is less than the lowest threshold</Name>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.QueryFetchTimeMonitor" SubElementID="Warning">
<Name>Fetch time is between upper threshold and lower threshold</Name>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.QueryFetchTimeMonitor" SubElementID="Error">
<Name>Fetch time has exceeded the upper threshold</Name>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.QueryExecutionTime">
<Name>$TemplateConfig/Name$ OLE DB Query Execution Time Performance Collection</Name>
<Description>Collects performance counter for time required for executing the query on the OLE DB data source.</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.QueryFetchTime">
<Name>$TemplateConfig/Name$ OLE DB Query Fetch Time Performance Collection</Name>
<Description>Collects performance counter for time required for fetching the results of the query from the OLE DB data source.</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.OleDbPerformanceCounter">
<Name>OLE DB Performance Monitor</Name>
<Description>Monitors performance of the OLE DB data source.</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.OleDbPerformanceCounter" SubElementID="OverThreshold1UnderThreshold2">
<Name>Between Thresholds</Name>
<Description>State of OLE DB performance monitor when performance counter is between the two threshold values</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.OleDbPerformanceCounter" SubElementID="OverThreshold2">
<Name>Over Upper Threshold</Name>
<Description>State of OLE DB performance monitor when performance counter is higher than the upper threshold value</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.OleDbPerformanceCounter" SubElementID="Threshold1">
<Name>Lower Threshold</Name>
<Description>Lower threshold value for OLE DB performance counter</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.OleDbPerformanceCounter" SubElementID="Threshold2">
<Name>Upper Threshold</Name>
<Description>Upper threshold value for OLE DB performance counter</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.OleDbPerformanceCounter" SubElementID="UnderThreshold1">
<Name>Under Lower Threshold</Name>
<Description>State of OLE DB performance monitor when performance counter value is lower than the lower threshold value</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.ConnectionTimeMonitor.AlertMessage">
<Name>$TemplateConfig/Name$ Connection Time Alert</Name>
<Description>The connection time of $TemplateConfig/Name$ has exceeded the alerting threshold. The connection time is {0}. The lower threshold value is $TemplateConfig/ConnectionTimeWarningThreshold$. And the upper threshold value is $TemplateConfig/ConnectionTimeErrorThreshold$.</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.QueryExecutionTimeMonitor.AlertMessage">
<Name>$TemplateConfig/Name$ Query Execution Time Alert</Name>
<Description>The execution time of $TemplateConfig/Name$ has exceeded the alerting threshold. The execution time is {0}. The lower threshold value is $TemplateConfig/QueryExecutionTimeWarningThreshold$. And the upper threshold value is $TemplateConfig/QueryExecutionTimeErrorThreshold$.</Description>
</DisplayString>
<DisplayString ElementID="$TemplateConfig/TypeId$.QueryFetchTimeMonitor.AlertMessage">
<Name>$TemplateConfig/Name$ Query Fetch Time Alert</Name>
<Description>The fetch time of $TemplateConfig/Name$ has exceeded the alerting threshold. The fetch time is {0}. The lower threshold value is $TemplateConfig/QueryFetchTimeWarningThreshold$. And the upper threshold value is $TemplateConfig/QueryFetchTimeErrorThreshold$.</Description>
</DisplayString>
</DisplayStrings>
<KnowledgeArticles>
<KnowledgeArticle ElementID="$TemplateConfig/TypeId$.NoConnectionMonitor">
<MamlContent>
<maml:section xmlns:maml="http://schemas.microsoft.com/maml/2004/10">
<maml:title>Summary</maml:title>
<maml:para>Connection to the data source could not be made or the query did not succeed in executing on the data source</maml:para>
</maml:section>
<maml:section xmlns:maml="http://schemas.microsoft.com/maml/2004/10">
<maml:title>Causes</maml:title>
<maml:para>
Depending on the conditions the failures could be categorized into connection failure and query failures. Review the Alert context to inspect the status code.
</maml:para>
<maml:table>
<maml:row>
<maml:entry>
<maml:para>Status code</maml:para>
</maml:entry>
<maml:entry>
<maml:para>Failure description</maml:para>
</maml:entry>
</maml:row>
<maml:row>
<maml:entry>
<maml:para>1</maml:para>
</maml:entry>
<maml:entry>
<maml:para>Data Source could not be initialized</maml:para>
</maml:entry>
</maml:row>
<maml:row>
<maml:entry>
<maml:para>2</maml:para>
</maml:entry>
<maml:entry>
<maml:para>Session could not be opened</maml:para>
</maml:entry>
</maml:row>
<maml:row>
<maml:entry>
<maml:para>3</maml:para>
</maml:entry>
<maml:entry>
<maml:para>Execution of query failed</maml:para>
</maml:entry>
</maml:row>
<maml:row>
<maml:entry>
<maml:para>4</maml:para>
</maml:entry>
<maml:entry>
<maml:para>Fetch failed</maml:para>
</maml:entry>
</maml:row>
</maml:table>
<maml:para>
If the failure description indicates "Data Source could not be initialized" or "Session could not be opened", it is a connection problem. For all others it is a query problem.
Conection failures can happen due to one or more of the following reasons:
</maml:para>
<maml:para/>
<maml:list>
<maml:listItem>
<maml:para>The connection string is erroneous</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Network is unavailable or slow or blocked</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Target Data source is offline</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Watcher node is not configured with appropriate permissions</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Watcher node does not have the OLE DB Data provider installed</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Target Data source is unavailable</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Maximum number of connections to the data source have been exceeded</maml:para>
</maml:listItem>
</maml:list>
<maml:para/>
<maml:para>
If the problem is due to a query failure, one or more of the following reasons may apply:
</maml:para>
<maml:para/>
<maml:list>
<maml:listItem>
<maml:para>Query is incorrect and has errors</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Database machine is out of resources and taking a long time to execute the query</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Query timeout has exceeded before the response from the data source causing an abort</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>The Data source is locked and rejecting all similar queries</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>The resulting Rowset is large and causing timeouts</maml:para>
</maml:listItem>
</maml:list>
</maml:section>
<maml:section xmlns:maml="http://schemas.microsoft.com/maml/2004/10">
<maml:title>Resolutions</maml:title>
<maml:para>Try the following troubleshooting steps to fix the problem</maml:para>
<maml:para/>
<maml:list>
<maml:listItem>
<maml:para>Ping the target computer running the data source from the watcher node</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Ensure that the proper credentials are configured in the RunAs Profile account for this OLE DB Data source transaction</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Check that the OLE DB data provider is installed on the machine</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Verify the query by running it locally on the data source</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Check that Query timeout is not too low</maml:para>
</maml:listItem>
</maml:list>
</maml:section>
</MamlContent>
</KnowledgeArticle>
<KnowledgeArticle ElementID="$TemplateConfig/TypeId$.ConnectionTimeMonitor">
<MamlContent>
<maml:section xmlns:maml="http://schemas.microsoft.com/maml/2004/10">
<maml:title>Summary</maml:title>
<maml:para>The connection initialization and opening is taking longer than the expected threshold</maml:para>
</maml:section>
<maml:section xmlns:maml="http://schemas.microsoft.com/maml/2004/10">
<maml:title>Causes</maml:title>
<maml:para>
Slow Conections can result due one or more of the following reasons:
</maml:para>
<maml:para/>
<maml:list>
<maml:listItem>
<maml:para>Network is slow</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>There are large number of open connections</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Data source machine is overloaded</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>The Data source process is running out of memory or CPU cycles</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Watcher node is experiencing resource overutilization</maml:para>
</maml:listItem>
</maml:list>
</maml:section>
<maml:section xmlns:maml="http://schemas.microsoft.com/maml/2004/10">
<maml:title>Resolutions</maml:title>
<maml:para>Try the following troubleshooting steps to fix the problem:</maml:para>
<maml:para/>
<maml:list>
<maml:listItem>
<maml:para>Check the length of time required to ping the remote machine hosting the data source</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Verify that network bandwidth is sufficient for making the database connection</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Make sure the host machine does not have resource problems</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Increase connection pool size to allow more connection, if exceeded</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Identify any resource problems on the watcher node causing performance and utilization issues</maml:para>
</maml:listItem>
</maml:list>
</maml:section>
</MamlContent>
</KnowledgeArticle>
<KnowledgeArticle ElementID="$TemplateConfig/TypeId$.QueryExecutionTimeMonitor">
<MamlContent>
<maml:section xmlns:maml="http://schemas.microsoft.com/maml/2004/10">
<maml:title>Summary</maml:title>
<maml:para>Query is taking a long time to execute the specified query for the target Data Source</maml:para>
</maml:section>
<maml:section xmlns:maml="http://schemas.microsoft.com/maml/2004/10">
<maml:title>Causes</maml:title>
<maml:para>
Slow Query execution can result due one or more of the following reasons:
</maml:para>
<maml:para/>
<maml:list>
<maml:listItem>
<maml:para>Network is slow</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>There are large number of open connections</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Data source machine is overloaded</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>The Data source process is running out of memory or CPU cycles</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Watcher node is experiencing resource overutilization</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Query is complex</maml:para>
</maml:listItem>
</maml:list>
</maml:section>
<maml:section xmlns:maml="http://schemas.microsoft.com/maml/2004/10">
<maml:title>Resolutions</maml:title>
<maml:para>Try the following troubleshooting steps to fix the problem:</maml:para>
<maml:para/>
<maml:list>
<maml:listItem>
<maml:para>Check the length of time required to ping the remote machine hosting the data source</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Verify that network bandwidth is sufficient for making the database connection</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Make sure the host machine does not have resource problems</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Increase connection pool size to allow more connection, if exceeded</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Identify any resource problems on the watcher node causing performance and utilization issues</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Break up the query into several simple queries</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Use Query profiling tools for diagnosing query problems</maml:para>
</maml:listItem>
</maml:list>
</maml:section>
</MamlContent>
</KnowledgeArticle>
<KnowledgeArticle ElementID="$TemplateConfig/TypeId$.QueryFetchTimeMonitor">
<MamlContent>
<maml:section xmlns:maml="http://schemas.microsoft.com/maml/2004/10">
<maml:title>Summary</maml:title>
<maml:para>Fetching the result from the specified query for the target Data Source are taking longer than expected</maml:para>
</maml:section>
<maml:section xmlns:maml="http://schemas.microsoft.com/maml/2004/10">
<maml:title>Causes</maml:title>
<maml:para>
Slow Query fetch can result due one or more of the following reasons:
</maml:para>
<maml:para/>
<maml:list>
<maml:listItem>
<maml:para>Network is slow</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>There are large number of open connections</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Data source machine is overloaded</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>The Data source process is running out of memory or CPU cycles</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Watcher node is experiencing resource overutilization</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Query is complex</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Results of the query are large</maml:para>
</maml:listItem>
</maml:list>
</maml:section>
<maml:section xmlns:maml="http://schemas.microsoft.com/maml/2004/10">
<maml:title>Resolutions</maml:title>
<maml:para>Try the following troubleshooting steps to fix the problem:</maml:para>
<maml:para/>
<maml:list>
<maml:listItem>
<maml:para>Check the length of time required to ping the remote machine hosting the data source</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Verify that network bandwidth is sufficient for making the database connection</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Make sure the host machine does not have resource problems</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Increase connection pool size to allow more connection, if exceeded</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Identify any resource problems on the watcher node causing performance and utilization issues</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Break up the query into several simple queries</maml:para>
</maml:listItem>
<maml:listItem>
<maml:para>Use Query profiling tools for diagnosing query problems</maml:para>
</maml:listItem>
</maml:list>
</maml:section>
</MamlContent>
</KnowledgeArticle>
</KnowledgeArticles>
</LanguagePack>
</LanguagePacks>
</Implementation>
</Template>
Home
FRA