Daily Logging Summary

×
This query is great for monitoring the health of the system. Just setup an ExportToEmail job to send you this queries results daily:
 
select
Severity, Count(*) AS [Count]
from bdlogging with(nolock)
where eventtime>='%Yesterday%' and eventtime<'%Today%'
group by Severity