rob mcnicol (2/1/2011)
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?
i subsequently found this:
http://www.sqlservercentral.com/articles/Profiler/63097/
the summary answer to my question is: paste the xmla code into a job step
thanks again
rob
That's good. And thanks for posting it back here. Other people who come along will find it useful.
"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