You administer a Microsoft SQL Server 2016 instance. You discover that the SQL Agent Error Log file is rapidly growing in size. You need to ensure that the SQL Agent Error Log file does not grow rapidly when SQL Server agent jobs execute. What should you do?
正解:E
Explanation/Reference: Because the Include execution trace messages option can cause the error log to become large, only include execution trace messages in SQL Server Agent error logs when investigating a specific SQL Server Agent problem. References: https://docs.microsoft.com/en-us/sql/ssms/agent/write-execution-trace-messages-to-sql- server-agent-log-ssms