LOGPARSER #6: Check daily bandwidth
This script checks for daily bandwidth. Great for spotting trends.
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)
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.
QUANTIZE(TO_TIMESTAMP(date, time), 3600) AS Hour,
SUM(sc-bytes) AS TotalBytesSent