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>