Office 365 and Azure
Run the below query the logs already ingested into your SIEM or use a manual sampling method.
OfficeActivity
| where TimeGenerated > ago(24h)
| summarize EventCount = count() by bin(TimeGenerated, 1s)
| summarize AvgEPS = avg(EventCount), MaxEPS = max(EventCount)If you don't have a SIEM yet and are trying to size one:
Go to the Microsoft Purview (Compliance) Portal > Audit.
Run a search for "All activities" for a specific 1-hour window during your busiest time (e.g., Monday at 10:00 AM).
Export the results to CSV.
The Math: * Take the total number of rows (events).
Divide by 3,600 (seconds in an hour).
Example: 18,000 events / 3,600 = 5 EPS.
Important Benchmarks
Office 365 log volume is usually "bursty." It stays low most of the time but spikes during morning logins or heavy file sharing.
Small Business (<250 users): Usually <2 EPS average.
Enterprise (5,000+ users): Can range from 20 to 100+ EPS depending on activity.
Primary Drivers: Azure AD Sign-in logs and SharePoint/OneDrive file operations usually make up 80% of the volume.
tags:
Office365 logs
Azure Logs