Advertisement

09.14.2007 at 07:49AM PDT, ID: 22829018
[x]
Attachment Details

Where else could an event be triggering an automated SQL Profiler trace

Asked by itdrms in SQL Server 2005

Tags: sql, automate, profiler, run, permission

I have discovered trace output in \MSSQLDATA\MSSQL.1\MSSQL\LOG that I have not kicked off.  It is at various times and limited to 20MB.  So that tells me a server event is kicking off a pre-defined trace.  The trace contains mostly hash warnings and sort warnings.

I have looked through my Agent Jobs, Agent Alerts, and perfmon and don't find anything that is set up to kick off a trace under a specified condition.

I have checked the job activity, SQL error logs, SQL server logs, and the server's event viewer for any odd events or event times that correlate with the times of the traces.

I have checked each database's sys.sql_modules for a definition containing '%sp_trace%'.

Where else can I check to find what would be triggering these traces?

Our app logins don't have permissions high enough to run traces, I verified:
"You do not have permission to run 'SP_TRACE_CREATE'"

This is Enterprise SQL 2005 64-bit SP2 running active/passive on a Win2003 SP2 clustered pair.
Start Free Trial
[+][-]09.14.2007 at 09:35AM PDT, ID: 19893025

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: SQL Server 2005
Tags: sql, automate, profiler, run, permission
Sign Up Now!
Solution Provided By: Yveau
Participating Experts: 1
Solution Grade: B
 
 
[+][-]09.14.2007 at 12:48PM PDT, ID: 19894638

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.14.2007 at 04:01PM PDT, ID: 19895673

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628