Random DBCC Trace | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Random DBCC Trace

Hi all,
was just looking through the application log on our live server and noticed that earlier this morning the DBCC Trace 3604 started and stopped in the same second according to the time stamps…I am 99% sure that i am the only one in my office that would have any idea how to start or stop a trace, and i definitely didnt start it, so am wondering if anyone has any suggestions as to how/why it would have happened?!?!? Thanks
Ben ‘I reject your reality and substitute my own’ – Adam Savage
Trace flag 3604 Trace flag 3604 sends trace output to the client. This trace flag is used only when setting trace flags with DBCC TRACEON and DBCC TRACEOFF. http://www.sql-server-performance.com/ac_2000_trace_flags.asp
Permissions [BOOKS ONLINE] DBCC TRACEON permissions default to members of the sysadmin fixed server role only, and are not transferable.
— You must check user those have ‘sysadmin’ permissions. Deepak Kumar –An eye for an eye and everyone shall be blind
ok, i know that no one in the office started and stopped it…so there must be something else that did it… ‘I reject your reality and substitute my own’ – Adam Savage
In this case try capturing server side trace to see the under-line events.
Even I also see such event when running database consistency checks during maintenance window. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Anything else running at about the same time on the server? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Sorry for not getting back to you on this one- subscribe still isnt working for me, and i dont get the rss feeds when im not logged in, so i have only just seen this now! Thanks for your help…auto update statistics is On on the database, so would i be right in thinking that this might have something to do with it?!? I have been running traces periodically and havent seen it again…there are no scheduled jobs that were running around that time. had a look through the application log today and havent seen it again 🙁 Maybe it will remain one of lifes little mysteries! ‘I reject your reality and substitute my own’ – Adam Savage
Even though auto update stats is SET on the database, intermittent execution of UPDATE STATISTICS will fetch good response for the queries. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>