Microsoft.SqlServer.Core.CustomMonitoring.UIPageSet.DBEngineCustomQueryPerfCollection (UIPageSet)
Element properties:
Source Code:
<UIPageSet ID="Microsoft.SqlServer.Core.CustomMonitoring.UIPageSet.DBEngineCustomQueryPerfCollection" TypeDefinitionID="Microsoft.SqlServer.Core.CustomMonitoring.RuleTemplate.DBEngine.CustomQueryPerfCollection">
<UIPageReferences>
<UIPageReference ID="Microsoft.SqlServer.Core.CustomMonitoring.UIPageSet.DBEngineCustomQueryPerfCollection.PageReference1" PageID="Microsoft.SqlServer.Core.CustomMonitoring.UIPage.DBEngineRuleGeneralPage" Usage="CreationOnly">
<InputParameters/>
<InputTransform>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="xml" indent="yes" omit-xml-declaration="yes"/>
<xsl:template match="/">
<xsl:element name="Category">
<xsl:copy>PerformanceCollection</xsl:copy>
</xsl:element>
</xsl:template>
</xsl:stylesheet>
</InputTransform>
</UIPageReference>
<UIPageReference ID="Microsoft.SqlServer.Core.CustomMonitoring.UIPageSet.DBEngineCustomQueryPerfCollection.Reference2" PageID="Microsoft.SqlServer.Core.CustomMonitoring.UIPage.SqlQueryPage" Usage="CreationAndUpdate">
<InputParameters/>
<InputTransform>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="xml" indent="yes" omit-xml-declaration="yes"/>
<xsl:template match="/">
<xsl:element name="Configuration">
<xsl:copy-of select="DatabaseName"/>
<xsl:copy-of select="SqlQuery"/>
<xsl:copy-of select="TimeoutSeconds"/>
<xsl:copy-of select="SqlTimeoutSeconds"/>
<xsl:copy-of select="SqlExecTimeoutSeconds"/>
</xsl:element>
</xsl:template>
</xsl:stylesheet>
</InputTransform>
</UIPageReference>
<UIPageReference ID="Microsoft.SqlServer.Core.CustomMonitoring.UIPageSet.DBEngineCustomQueryPerfCollection.PageReference3" PageID="Microsoft.SqlServer.Core.CustomMonitoring.UIPage.PerfCounterPage">
<InputParameters/>
<InputTransform/>
</UIPageReference>
<UIPageReference ID="Microsoft.SqlServer.Core.CustomMonitoring.UIPageSet.DBEngineCustomQueryPerfCollection.Reference4" PageID="System!System.SimpleSchedulerPage">
<InputParameters/>
<InputTransform>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="xml" indent="yes" omit-xml-declaration="yes"/>
<xsl:template match="/">
<xsl:element name="SimpleReccuringSchedule">
<xsl:element name="Interval">
<xsl:choose>
<xsl:when test="IntervalSeconds">
<xsl:value-of select="IntervalSeconds"/>
</xsl:when>
<xsl:otherwise>900</xsl:otherwise>
</xsl:choose>
</xsl:element>
<xsl:if test="boolean(string-length(SyncTime))">
<xsl:copy-of select="SyncTime"/>
</xsl:if>
</xsl:element>
</xsl:template>
</xsl:stylesheet>
</InputTransform>
</UIPageReference>
</UIPageReferences>
<OutputTransform>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="xml" indent="yes" omit-xml-declaration="yes"/>
<xsl:template match="/">
<xsl:element name="Configuration">
<xsl:copy-of select="/ID"/>
<xsl:copy-of select="/Name"/>
<xsl:copy-of select="/Enabled"/>
<xsl:copy-of select="/Description"/>
<xsl:copy-of select="/Target"/>
<xsl:copy-of select="/Category"/>
<xsl:copy-of select="/LocaleId"/>
<xsl:if test="/PropertyReferenceMonitoringType">
<xsl:element name="MonitoringType">
<xsl:value-of select="/PropertyReferenceMonitoringType"/>
</xsl:element>
</xsl:if>
<xsl:copy-of select="/DatabaseName"/>
<xsl:copy-of select="/SqlQuery"/>
<xsl:copy-of select="/PerfCounters"/>
<xsl:copy-of select="/SqlExecTimeoutSeconds"/>
<xsl:copy-of select="/SqlTimeoutSeconds"/>
<xsl:copy-of select="/TimeoutSeconds"/>
<xsl:element name="IntervalSeconds">
<xsl:variable name="RawInterval" select="/SimpleReccuringSchedule/Interval"/>
<xsl:variable name="Units" select="/SimpleReccuringSchedule/Interval/@Unit"/>
<xsl:choose>
<xsl:when test="not(boolean($Units)) or $Units='Seconds'">
<xsl:value-of select="$RawInterval"/>
</xsl:when>
<xsl:when test="$Units='Minutes'">
<xsl:value-of select="$RawInterval*60"/>
</xsl:when>
<xsl:when test="$Units='Hours'">
<xsl:value-of select="$RawInterval*3600"/>
</xsl:when>
<xsl:when test="$Units='Days'">
<xsl:value-of select="$RawInterval*86400"/>
</xsl:when>
</xsl:choose>
</xsl:element>
<xsl:element name="SyncTime">
<xsl:value-of select="/SimpleReccuringSchedule/SyncTime"/>
</xsl:element>
<xsl:element name="Publisher">
<xsl:value-of select="/PropertyReferencePublisher"/>
</xsl:element>
</xsl:element>
</xsl:template>
</xsl:stylesheet>
</OutputTransform>
</UIPageSet>