Categories
General

Day 3–Trace Flag 3688–Suppress Trace information from Errorlog

In one of our development server we will be frequently running trace files to capture information for performance trouble shooting. However this in turn writes so many entries about trace file in errorlog which fills the errorlog. Errorlog entry is big and we are not to search it easily so to avoid the trace information we used trace flag 3688 in startup parameter of SQL Server. Refer KB article http://support.microsoft.com/kb/922578 for more.