How to schedule SQL profiler to auto start/stop to capture SSAS synchronization?

Komal Sahu 311 Reputation points
2020-08-12T15:14:58.907+00:00

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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,242 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-08-13T02:21:41.197+00:00

    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

    1 person found this answer helpful.
  2. Komal Sahu 311 Reputation points
    2020-11-23T14:58:32.987+00:00

    All,

    Follow This QnA for the answer to automate profiler for SSAS event capture.

    Thanks

    0 comments