Turning off absolutely all server traces SET TRACEOFF=ALL

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6821045303

October 22, 2008, 11:32 AM

hammo1j

Turning off absolutely all server traces SET TRACEOFF=ALL

According to advanced search this scotches all tracing.

SET TRACEOFF=ALL
SET TRACEOFF=EDAAPI
SET TRACEOFF=ODIN

The default in SRV76\WFS\CATALOG\WFTRACE.FEX seems to be

SET TRACEON=DEFAULT

which produces quite an amount of trace output in EDATEMP.

Anyone had any problems with switching all traces off since it does seem to improve performance. We are trying in the TEST server but dont want to risk production just yet.

nb You need to reboot server to see the trace settings change.

Check your TRACE setting with SET TRACEON=?

Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo

October 22, 2008, 11:53 AM

GinnyJakes

We have the default that you show but it is in ibitrace.fex. The only traces we get in edatemp with that are the Workspace Manager and Listeners default traces. We get traces in Data Services if developers leave trace commands in their programs that check out their SQL. If you can control that, I'm not sure I would turn them off completely. We just go in and delete the DS traces now and then.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google