in More Search Options

Questionable values for SQL report - Packets per second

Last post 08-21-2007 11:28 AM by Ishikawa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts:
  • 08-15-2007 12:57 PM

    • jp
    • Top 100 Contributor
    • Joined on 10-25-2006
    • Posts 76
    • Points 193

    Questionable values for SQL report - Packets per second

    I'm using this simple query, hoping to find out the daily max usage of any given device in the network.

    I'm going by this PDF:http://www.cisco.com/web/partners/downloads/765/tools/quickreference/routerperformance.pdf as a reference for estimated packets per second and Mbps.

    The returned PPS and my perceived performance don't seem to match up.

    What I'm trying to do is add up the InBps, OutBps, packets per second, packet sizes, etc, and add all of the interfaces on the device for a general "Throughput" report.

    One of my problems here is that I can't seem to find a database field for a peak packets per second in a day, even in InterfaceTraffic.

    This report is named "Capacity Report" and I'm afraid it's not completely accurate enough to make upgrade assessments.

    Can I ask someone to create a custom orion sql report and run this query and see if it adds up to what they think it should look like?
     

    select i.NodeID, n.Caption, ROUND(SUM(InPps + OutPps),0) as TotalPps, ROUND(SUM(InPktSize+ OutPktSize),0) AS TotalPktSize, ROUND(SUM(MaxInBpsToday + MaxOutBpsToday),0) AS TotalMaxBpsToday, ROUND(SUM(InDiscardsToday + InErrorsToday + OutDiscardsToday + OutErrorsToday),0) AS TotalErrors
    FROM Interfaces i
    INNER JOIN Nodes n
    ON i.NodeID = n.NodeID
    WHERE i.InterfaceSpeed != 0
    GROUP BY i.NodeID,n.Caption

     

     

    My opinions are of my own, and not those of my employers
    • Post Points: 3
  • 08-21-2007 11:28 AM In reply to

    • Ishikawa
    • Top 100 Contributor
    • Joined on 05-16-2007
    • Dallas, TX
    • Posts 78
    • Points 184

    Re: Questionable values for SQL report - Packets per second

    JP,

     I think you may be overcomplicating your appraoch. If you explore the field in t eh database wuo will see that there are already fields for In and Out total byte and packet counts. I would use those myself. Alternately you could use netflow.

    Cheers,

     

    Dan Wendeln
    Sr. Field Application Engineer
    SolarWinds
    • Post Points: 1
Page 1 of 1 (2 items)