One of the most important things in database administration is monitoring. For example, you want to know if unauthenticated users are reading data, if the system is throwing errors, if there is wrong data somewhere, and the amount of time that sessions are taking. This monitoring needs automation to catch things up when they occur. Relying solely on manual log reviews is inefficient and prone to oversight. Initiative-taking monitoring prevents escalation of issues before end users report them to management.
SQL Server has a flight recorder since version 2008, named “system_health*.xel”, and you can read it using T-SQL. SQL Server Analysis