I have Upgraded SQL SERVER from 2008R2 to 2014 and all of a sudden i was seeing too much information about checkpoint, flush avg wait time etc ...in SQL Server error logs ..
I tried looking at DBCC TRACESTATUS
i see 3502,3504 set to on ...
i turn them off like below and no more information being logged
DBCC TRACEOFF(3504,-1 )
go
DBCC TRACEOFF (3502, -1);
GO
--3502,3504 Checkpoint , flush etc
No comments:
Post a Comment