Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Traces running with NULL FileName,MaxSize values Expand / Collapse
Author
Message
Posted Monday, August 06, 2012 7:46 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:21 PM
Points: 1,269, Visits: 2,328
On one of our servers we can see 3 traces running with NULL FileName, NULL MaxSize. When geting the data from sys.fn_trace_getinfo values are NULL for property 2,3&4. Value 1 is returned for properties 1 & 5.

Could anybody help to understand this or if anybody else has experienced the same situation earlier?



Sujeet Singh
Post #1340608
Posted Monday, August 06, 2012 7:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:16 PM
Points: 12,755, Visits: 31,121
wierd;
i cannot get a trace to be created with either the options or the filename to be null;
it's wierd that you are able to see that.


i tried stuff like stopping my example traces, but that just changes the status; doesn't affect teh otehr parameter values.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1340627
Posted Monday, August 06, 2012 8:07 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:21 PM
Points: 1,269, Visits: 2,328
Lowell (8/6/2012)
wierd;
i cannot get a trace to be created with either the options or the filename to be null;
it's wierd that you are able to see that.


i tried stuff like stopping my example traces, but that just changes the status; doesn't affect teh otehr parameter values.


Yes, that's what I thought when I saw that. I am not sure whether they are running or not. As value for property 5 is 1, they must be runinng but then where are they putting this trace data ?



Sujeet Singh
Post #1340639
Posted Monday, August 06, 2012 8:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:38 PM
Points: 2,673, Visits: 3,326
Strange... What about the TRACE_PRODUCE_BLACKBOX option?

From BOL: No filename can be specified. The file will be saved as: N'%SQLDIR%\MSSQL\DATA\blackbox.trc'

Don't have time to set one up and test it, but maybe that is what is going on?


Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1340654
Posted Tuesday, August 07, 2012 5:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:21 PM
Points: 1,269, Visits: 2,328
After digging in it looks like it is not a server side trace or a profiler trace. When checked from sys.dm_exec_sessions the host process is SQL Server Analysis Services & from sys.dm_exec_requests wait_type is TraceWrite.

I am still not sure what kind of trace it could be or if traces could be run by Analysis Services?



Sujeet Singh
Post #1341171
Posted Tuesday, August 07, 2012 8:04 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:21 PM
Points: 1,269, Visits: 2,328
Okay, I think I got it now . These are special traces run by SQL Server to provide proactive caching & notifications to SSAS.

It is well explained on jason's blog here & on following MSDN links:

1. Notifications to SSAS
2. Proactive Caching



Sujeet Singh
Post #1341288
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse