I know the profiler extension on Azure data studio basically makes use of extended events under the hood. I can start the profiler using Azure Data Studio and can see the system logs on the screen. However, when I stop the trace session on the screen, and when I click on the [Select View] option on the top right, all the data that was collected initially gets lost.
How do I know where the original trace was saved or is there a save option specifically?
Hi @moboy-9601,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Hi @moboy-9601,
In Azure Data Studio, SQL Profiler is a preview version while in SSMS it is not. You can use it in SSMS and it supports Save as.
Please refer to the official document: https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler?view=sql-server-ver15
Note: SQL Profiler will probably be gradually replaced by Extended Events in the future.
In SSMS,
https://www.mssqltips.com/sqlservertutorial/3508/how-to-save-sql-server-trace-data-to-a-file/
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
16 people are following this question.
