Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Grant Fritchey Set Up And Schedule a Server Side Trace RE: Set Up And Schedule a Server Side Trace

  • February 1, 2011 at 4:09 am

    #1280835

    rob mcnicol (1/31/2011)

    great article, thanks.

    what tweaks to this process are required to run a server-side trace on analysis services? when i export my Script Trace Definition, the 'For SQL...' options are greyed out. i am only able to export 'For Analysis Services...' which produces an xmla file.

    what do i do with that xmla file to schedule the trace?

    my task at hand is that i have to create an audit of access to a cube. any thoughts on whether this is a sufficiently robust mechanism to do this? if not, can anyone suggest alternatives?

    thanks

    rob

    I am frankly unsure. I've never run a trace on SSAS, so I don't know exacty how it works.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning