4 Replies Latest reply on Jan 4, 2017 4:59 PM by tdanner

    Orion.PerformanceCounters

    silmaril2333

      I'm trying to extract the raw performance information using the Orion API. I've tried SWQL Studio but I get the following error:

       

      SolarWinds.Data.Query.ParserException: The parameter(s) 'Category' are missing for entity Orion.PerformanceCounters

       

      Using the following query:

       

      SELECT CategoryName, InstanceName, CounterName, RawValue FROM Orion.PerformanceCounters

        • Re: Orion.PerformanceCounters
          tdanner

          This entity uses an obscure SWQL feature for parameters. SWQL Studio doesn't show this in the tree, so there's not really any way to discovery it. You can use it like this:

           

          SELECT CategoryName, InstanceName, CounterName, RawValue

          FROM Orion.PerformanceCounters(Category='Processor')

           

          or

           

          SELECT CategoryName, InstanceName, CounterName, RawValue

          FROM Orion.PerformanceCounters(Category='.NET CLR Memory')

           

          You can see the available categories in the Windows "perfmon" tool.

          1 of 1 people found this helpful