There is no direct option to extract the SQL profile result in Excel or CSV file. We need to use fn_trace_gettable() in SQL server.
Let’s see step by step how to extract SQL profiler result in excel file.
Open SQL server and profiler.
Here I am running below SQL query.
See it in profiler.
Now we need to save this result in .trc file
I saved this with name abc.trc file.
Now open the query window and run the below query
Now we can save the query result in excel or csv file.
|
select * from fn_trace_gettable('D:\abc.trc',default)
|
Here I am saving it in csv format.
We can add the filer on the function to retrieve the profiler result for the particular user.
|
select TextData,ApplicationName,LoginName,StartTime,EndTime,
ServerName,NTDomainName,NTUserName from fn_trace_gettable('D:\abc.trc',default)
where NTUserName='Bagesh'
|
Thanks for the informative and helpful post, obviously in your blog everything is good..
ReplyDeletedownload notepad++ for mac
you r a life saver
ReplyDeleteI appreciate you taking the time and effort to share your knowledge. This material proved to be really efficient and beneficial to me. Thank you very much for providing this information. Continue to write your blog.
ReplyDeleteData Engineering Services
Machine Learning Services
Data Analytics Services
Data Modernization Services
I am not rattling good with English but I get hold this very easygoing to read . แทงหวย
ReplyDelete"I love how savory and sweet this flavor is." Fryd carts
ReplyDeleteI always enjoy reading your articles. I already bookmark your website to visit often. Thank you so much for always sharing such an insightful information. Discount Ongoing on our Fryd Carts. Visit our website to Buy Fryd Carts Online. Buy Premium Fryd Donuts 2g Disposable Nearby.
ReplyDeleteThank you so much for sharing this insightful blog post. I really appreciated the thoughtful perspective and the valuable information you provided. It’s clear you put a lot of effort into it, and it definitely made me think. Looking forward to reading more from you! Visit our website to Buy Nembutal Online . Find Nembutal for Sale. Explore our shop page.
ReplyDeleteWow, this is such an insightful post! I really appreciate the depth of your perspective and the practical tips you shared. It's inspiring to see content that combines both knowledge and authenticity. Looking forward to reading more from you—thanks for sharing your expertise!" We currently have Mimosa Hostilis Root Bark for Sale . Explore Our Shop To Buy Mimosa Hostilis from Trusted Vendors.
ReplyDeleteThis information is very helpful and I find so much meaning reading each if your articles. Thank you for always sharing. Please check out our 8 Ball of Cocaine and learn more. Explore Our Shop To Buy Cocaine Online . We are currently running out discounts this week.
ReplyDelete