InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 05:22:07 GMT20http://www.sqlservercentral.com/Forums/Topic947173-1550-1.aspxOops....Mon, 14 Nov 2011 04:03:52 GMTyuphttp://www.sqlservercentral.com/Forums/Topic947173-1550-1.aspxDudeThis post is well over a year old ;-)Sun, 13 Nov 2011 21:12:10 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic947173-1550-1.aspx[quote][b]Zeal-DBA (7/3/2010)[/b][hr]ya i have seen so many trace flags list even i can ON any trace by dbcc but dont knw after that hw can i get benefit of that, will you please explain me some more abt trace flags and how they are completely differentfrom server side traces[/quote]You may like to check http://www.sqlservercentral.com/articles/trace+flags/70131/ for a list of trace flags.Sun, 13 Nov 2011 12:10:59 GMTyuphttp://www.sqlservercentral.com/Forums/Topic947173-1550-1.aspx[quote][b]sachinsoni84 (7/3/2010)[/b][hr]i have seen in the path 'Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG'thr are multiple errorlog file how wud i knw in which file my trace flag is being saved?[/quote]are you referring to the files for the default trace. There will be 5 files at any one time and hold most recent logged infoSun, 04 Jul 2010 11:08:15 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic947173-1550-1.aspxThe latest is always called ERRORLOGAnd not all traceflags cause things to be written to the error log. 1222 was [b]one specific example[/b] that I gave. There are traceflags that do many, many other things, from disabling lock escalation to changing how SQL reads from the disks. You should never enable a traceflag without knowing exactly what it will do.Sat, 03 Jul 2010 07:25:25 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic947173-1550-1.aspxi have seen in the path 'Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG'thr are multiple errorlog file how wud i knw in which file my trace flag is being saved?Sat, 03 Jul 2010 06:37:01 GMTZeal-DBAhttp://www.sqlservercentral.com/Forums/Topic947173-1550-1.aspxAs I said, server-side traces (just like Profiler) lets you see when various things happen in SQL (stored procedure begins, stored procedure ends, login succeeds, login fails, etc)Traceflags change the behaviour of the SQL engine (eg if traceflag 1222 is enabled, information on deadlocks is written to the SQL error log. )There are lots of documented traceflags, there are lots of undocumented traceflags, I don't know if there's a comprehensive list anywhere. Some are in books Online. Start there.Sat, 03 Jul 2010 06:07:39 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic947173-1550-1.aspxya i have seen so many trace flags list even i can ON any trace by dbcc but dont knw after that hw can i get benefit of that, will you please explain me some more abt trace flags and how they are completely differentfrom server side tracesSat, 03 Jul 2010 05:38:41 GMTZeal-DBAhttp://www.sqlservercentral.com/Forums/Topic947173-1550-1.aspxServer-side traces (sp_create_trace) and traceflags (DBCC traceon) are completely different concepts.Server-side traces are essentially profiler traces without the GUI, they log when events occur on the instance being traced, such as login failures, stored procedure executions, errors, etc. You can use the profiler GUI to generate the script to create the trace for you.Traceflags can be enabled or disabled (there are lots and lots of different traceflags) and they change certain aspects of SQL's behaviour.For server-side traces, try a google search. Lots of information turns up with a simple search.Sat, 03 Jul 2010 05:00:40 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic947173-1550-1.aspxhello experts, i am huge confuge about traces, i found that we can create trace through sp_crete_trace or we can ON trace through dbcc traceon(?), thrs a term server side tracing i heard, and some trace event i have seen in sys.traces, i am totally confuged wid traces, i wanna clear that whole concept n which trace how work pls helpSat, 03 Jul 2010 03:45:18 GMTZeal-DBA