9 Replies Latest reply on Oct 4, 2012 11:00 AM by lundrog

    Reporting on Node and Application Performance with SAM

    lundrog

      Last week I wrote on Providing Application insight, and understanding.

       

      This week I am talking about Application and Node reports within SAM.

       

      Everyone likes consistent results. No matter if it is a application owner, Supervisor, or Management. Allowing them to pull reports is a fundamental change, in that they can bypass the system admin, or application admin.

       

      When at the SAM console, click home, and reports.

       

      924-1.PNG

      Here you see all the reports. Today I want to look at a couple of the ones I find my self in often.

       

      Applications reports show availability, CPU, or Memory reports and more as seen below.

      924-2.PNG

       

      System paging is something that can impact SAN performance,

       

      In the page file usage report, it gives you a good idea what is paging. How much it is paging. And what the last X days has been like.

       

      server

       

      9/17/2012

      1. 45.4146671976362

       

      9/18/2012

      1. 45.2955087423325

       

      9/19/2012

      1. 45.3585888544718

       

      9/20/2012

      1. 45.3096214135488

       

      9/21/2012

      1. 46.1047437455919

       

      9/22/2012

      1. 45.2725427150726

       

      9/23/2012

      1. 45.3026424922745

       

      9/24/2012

      1. 45.3409397168593

      server01

       

      9/17/2012

      1. 45.30072171913

       

      9/18/2012

      1. 45.2674474981096

       

      9/19/2012

      1. 45.3227962123023

       

      9/20/2012

      1. 45.3232553402583

       

      9/21/2012

      1. 45.386402686437

       

      9/22/2012

      1. 45.3697840770086

       

      9/23/2012

      1. 45.3318119643056

       

      9/24/2012

      1. 45.4799940802834

      server02

       

      9/17/2012

      0

       

      9/18/2012

      0

       

      9/19/2012

      0

       

      9/20/2012

      0

       

      9/21/2012

      0

       

      9/22/2012

      0

       

      9/23/2012

      0

       

      9/24/2012

      0

      Server03

       

      9/17/2012

      1. 0.610446158419834

       

      9/18/2012

      1. 0.642984814527962

       

      9/19/2012

      1. 0.602786724766096

       

      9/20/2012

      1. 0.620250122000774

       

      9/21/2012

      1. 0.653511808564266

       

      9/22/2012

      1. 0.641215021204617

       

      9/23/2012

      1. 0.624988194555044

       

      9/24/2012

      1. 0.690394653933389


      Interesting yes? Then we could dig in to one of the server's, and see what is going on.

      924-8.png

       

       

       

      Node reports give a variety of information.

       

      924-6.PNG

       

      Let's dig into Current CPU load, this is one of my Favorites

       

      Current CPU Load

       

      server01

      63 %

      server02

      48 %

      server03

      43 %

      server04

      39 %

      server05

      38 %

      server06

      24 %

      server07

      17 %

      server08

      12 %

      server09

      8 %

      server001

      6 %

      server002

      5 %

      server003

      5 %

      server004

      %

      server005

      5 %

       

      Of course at any time in these reports you can dig in to a deeper level.

       

      924-7.PNG

       

      Collaboration is key, but allowing a easy view into your environmental via reports is a great way to quickly dig into application or node performance.

       

       

      As always, I'm just scratching the surtfice of what you can do with a tool like SAM. I hope I have shown you something useful today..

       

       

      Thanks

       

       

      Roger Lund

        • Re: Reporting on Node and Application Performance with SAM
          Sohail Bhamani

          One of my favorite things to do is to use the resource called "Report from Report Writer" to embed the handy report data in views.  This works especially well for C*O or super high level views.  I use this quite often with my customers and so far, they have worked quite well.

           

          Sohail Bhamani

          http://www.loop1systems.com

          • Re: Reporting on Node and Application Performance with SAM
            byrona

            With report writer you can do some very cool things if you know a tad bit of SQL and take the time to get familiar with the Orion database structure which is relatively simple.  I have made several business metrics dashboards for computing the compute densities in our different cloud environments.  It makes Orion show very well for the C level folks as Sohail noted.

            • Re: Reporting on Node and Application Performance with SAM
              rfletcher

              I'm still rather new to SAM and it's capabilities, but I've really liked reports that i can take to our server team with the problems that we're seeing on a daily basis. I've used reports to show which servers were in need of upgrades based on usage and memory used. I really look forward to seeing what I can do with 5.2 which we're updating soon.

              • Re: Reporting on Node and Application Performance with SAM
                IGFCSS.DSI

                Hi,

                I have an old version of Orion Network Monitor and one of our main issues when analyzing availability was the "availability definition". For us availability is measured only during work hours, non work hours are considered  maintenance time. I had to build custom queries for custom reports based only on working hours. Unfortunately, the daily reports are quite accurate but weekly, monthly and yearly reports summarize/aggregate values (due to lots of data to manage) and that looses some availability data. Servers are considered available on those periods of time even if they have small time windows of unavailability...

                 

                Well, can't have everything!!! But this is a great tool to work with...

                • Re: Reporting on Node and Application Performance with SAM
                  kmaxwell

                  I'd also like to see some canned Availability Reports based on business hours.  I hear this request pretty frequently at customer sites.  That and the ability for users to modify report fields/filters via the web interface would be awesome.

                    • Re: Reporting on Node and Application Performance with SAM
                      IGFCSS.DSI

                      Hi Maxwell,

                       

                      It's not very difficult to create those custom reports, if you know something about SQL and using Orion Report Writer. First of all, let me just add that my version of Orion is a very old one, ok? Due to budget issues it's been a while since we've bought this license and I couldn't renew it. I expect current versions to be a little different but the principles are fairly the same...

                       

                      Here is my custom report SQL query for "Weekly Availability - Servers"

                      --------------------------------------------------------------------------------------------------

                      declare @hoje as datetime

                      --Alterar valor 0 para modificar intervalo de tempo (reduzir dias ao dia corrente até ser Sábado)
                      -- Semana: Domingo -> Sábado
                      set @hoje=dateadd(day,0,GetDate())

                      declare @sDataInicio as varchar(10)
                      declare @sDataFim as varchar(10)

                      ------------------------------
                      --Últimos 7 Dias
                      -------------------------------
                      SET @sDataInicio=convert(varchar(10),dateadd(day,-6,@hoje),121)
                      SET @sDataFim=convert(varchar(10),@hoje,121)

                      SELECT CONVERT(DateTime,
                      LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),
                      101) AS SummaryMonth,
                      datepart(week,datetime) as Week,
                      Nodes.VendorIcon AS Vendor_Icon,
                      Nodes.Caption AS NodeName,
                      Nodes.IP_Address AS IP_Address,
                      AVG(ResponseTime.Availability) AS AVERAGE_of_Availability,
                      AVG(ResponseTime.AvgResponseTime) AS AVERAGE_of_RT,
                      MAX(ResponseTime.MaxResponseTime) AS MAX_of_RT

                      FROM
                      Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)


                      WHERE
                      ( convert(varchar(10),DateTime,121) BETWEEN @sDataInicio AND @sDataFim )
                      AND 
                      (
                        (DatePart(Hour,DateTime) >= 9) AND
                        (DatePart(Hour,DateTime) <= 18) AND
                      ((Nodes.IP_Address = '172.X.Y.Z') OR
                      (Nodes.IP_Address = '172.X.Y.Z') OR
                      ........

                      (Nodes.IP_Address = '172.X.Y.Z'))
                      )


                      GROUP BY CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101), datepart(week,datetime),
                      Nodes.VendorIcon, Nodes.Caption, Nodes.IP_Address

                      ORDER BY SummaryMonth ASC, Nodes.VendorIcon

                      ---------------------------------------------------------------------------------------------------------------------

                       

                      Explaining what we did....

                      First we declare the time interval when want (for us it's from Sunday to Saturday). This definition is useful when we need the same custom report with a different time interval! Select the info from the nodes and filter for the IP Address of the relevant nodes and business hours from 9h00 to 18h00... et voilá!!!

                       

                      For monthly and yearly reports, the principles are the same but with different timespan.

                       

                      Hope this is useful.

                    • Re: Reporting on Node and Application Performance with SAM
                      Chrystal Taylor

                      I definitely agree that there are some great canned reports.  More often though, I find myself building custom reports for clients.  Lately, I have been doing more and more custom SQL stuff to get what clients are looking for in a single report.  Joining multiple tables together to get a seamless view.  I will also agree being able to set a more specific custom time frame when building a report would be nice, like we already have when building our trigger actions for advanced alerts.  Also, constantly being asked about graphs for manager level reports.  Just my 2 cents.

                       

                      Chrystal Taylor

                      http://www.loop1systems.com