I want to minimize the output of certain warnings and messages in the SQL Server 2012 logs, such as when an spid is killed. I am unable to find information on suppressing/expanding which messages are actually sent to the error logs. Is this done through trace flags?
I am trying to reduce the number of warnings on our development database server and restrict it to legitimate errors. We have devs killing spids or flushing the query cache for performance tuning (playing with index tuning, forcing intentional table contention, creating deadlocks, etc), across multiple databases on the same server. Having a log file filled with these warnings is just an annoyance that I wanted to see if it were possible to suppress.