LOGPARSER #6: Check daily bandwidth


This script checks for daily bandwidth. Great for spotting trends.

Select
     To_String(To_timestamp(date, time), 'MM-dd') As Day,
     Div(Sum(cs-bytes),1024) As Incoming(K),
     Div(Sum(sc-bytes),1024) As Outgoing(K)
Into BandwidthByDay.gif
From
    logs\iis\ex*.log
Group By
    Day

image

You can also convert this into local time and check bytes sent by the server. We used this at my customer to check at what time a day we had the most traffic/datausage. We needed to create a IIS memory dump with as much data/traffic as possible but didn’t know the best time for it.

SELECT   
    QUANTIZE(TO_TIMESTAMP(date, time), 3600) AS Hour,
    SUM(sc-bytes) AS TotalBytesSent
INTO BytesSentPerHour.gif
FROM
    logs\iis\ex*.log
GROUP BY
    Hour
ORDER BY
    Hour

image

//Anders

Skip to main content