All,
Follow This QnA for the answer to automate profiler for SSAS event capture.
Thanks
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi All,
I am already troubleshooting an issue in synchronization of SSAS DB from source server to destination server . It is getting hanged.
I want to run the SQL profiler to capture the traces while synch job running. But I am not able to find any way where I can schedule any job or anything similar which auto-trigger SQL profiler when to capture synch job at particular time. Do anyone has any idea on this?
Thanks
Hi,
How have you run the synchronization? Was it scheduled for a specific time in a day?
We could write a Stored Procedure to schedule SQL Profiler job. For this tutorial in blog, add trace job into the code, it should work as required: Scheduling a SQL Server Profiler Trace
Hope this helps.
Regards,
Lukas