2012.10.17 SQL trace 해제
SQLDB 2005
SQL Server 2005 has a default trace running by default. This can be switched
off by using sp_configure i.e.
exec sp_configure 'show advanced
options',1
reconfigure
exec sp_configure 'default trace
enabled',0
reconfigure
However, this default trace is very lightweight
and is very unlikely to be
causing any issues. I would just filter that wait
type from you results.