October 31, 2018 at 12:27 pm
I am trying to run the trace on one of my server but this is what I am getting when I open it up in a notepad or even in SSMS.
搀攀渀琀椀昀椀攀爀 漀昀昀ഀ猀攀琀 愀爀椀琀栀愀戀漀爀琀 漀昀昀ഀ猀攀琀 渀甀洀攀爀椀挀开爀漀甀渀搀愀戀漀爀琀 漀昀昀ഀ猀攀琀 愀渀猀椀开眀愀爀渀椀渀最猀 漀渀ഀ猀攀琀 愀渀猀椀开
This is how I am creating a trace.
connect to server
tools>profiler
event selection
run the profiler and stop it right away
save the file as a .trc file and that's it.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
October 31, 2018 at 1:29 pm
Administering Databases - Wednesday, October 31, 2018 12:27 PMI am trying to run the trace on one of my server but this is what I am getting when I open it up in a notepad or even in SSMS.æ€æ”€æ¸€ç€æ¤€æ˜€æ¤€æ”€çˆ€â€€æ¼€æ˜€æ˜€à´€à¨€çŒ€æ”€ç€â€€æ„€çˆ€æ¤€ç€æ €æ„€æˆ€æ¼€çˆ€ç€â€€æ¼€æ˜€æ˜€à´€à¨€çŒ€æ”€ç€â€€æ¸€ç”€æ´€æ”€çˆ€æ¤€æŒ€å¼€çˆ€æ¼€ç”€æ¸€æ€æ„€æˆ€æ¼€çˆ€ç€â€€æ¼€æ˜€æ˜€à´€à¨€çŒ€æ”€ç€â€€æ„€æ¸€çŒ€æ¤€å¼€çœ€æ„€çˆ€æ¸€æ¤€æ¸€æœ€çŒ€â€€æ¼€æ¸€à´€à¨€çŒ€æ”€ç€â€€æ„€æ¸€çŒ€æ¤€å¼€
This is how I am creating a trace.
connect to server
tools>profiler
event selection
run the profiler and stop it right away
save the file as a .trc file and that's it.
You need to open it in Profiler or query the file with use fn_trace_gettable
Sue
October 31, 2018 at 3:50 pm
A .trc file is a binary file, so you should expect to get garbage when you open it in a text editor.
What are you trying to do?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2018 at 10:37 pm
Administering Databases - Wednesday, October 31, 2018 12:27 PMI am trying to run the trace on one of my server but this is what I am getting when I open it up in a notepad or even in SSMS.æ€æ”€æ¸€ç€æ¤€æ˜€æ¤€æ”€çˆ€â€€æ¼€æ˜€æ˜€à´€à¨€çŒ€æ”€ç€â€€æ„€çˆ€æ¤€ç€æ €æ„€æˆ€æ¼€çˆ€ç€â€€æ¼€æ˜€æ˜€à´€à¨€çŒ€æ”€ç€â€€æ¸€ç”€æ´€æ”€çˆ€æ¤€æŒ€å¼€çˆ€æ¼€ç”€æ¸€æ€æ„€æˆ€æ¼€çˆ€ç€â€€æ¼€æ˜€æ˜€à´€à¨€çŒ€æ”€ç€â€€æ„€æ¸€çŒ€æ¤€å¼€çœ€æ„€çˆ€æ¸€æ¤€æ¸€æœ€çŒ€â€€æ¼€æ¸€à´€à¨€çŒ€æ”€ç€â€€æ„€æ¸€çŒ€æ¤€å¼€
This is how I am creating a trace.
connect to server
tools>profiler
event selection
run the profiler and stop it right away
save the file as a .trc file and that's it.
Be careful when posting what looks to you like random streams of foreign text. It just be ASCII text interpreted as Unicode. In this case, it's an uninteresting part of the a T-SQL script, but there could have been some interesting things in there: SELECT convert(varchar(2000), convert(varbinary(2000), N'æ€æ”€æ¸€ç€æ¤€æ˜€æ¤€æ”€çˆ€â€€æ¼€æ˜€æ˜€à´€à¨€çŒ€æ”€ç€â€€æ„€çˆ€æ¤€ç€æ €æ„€æˆ€æ¼€çˆ€ç€â€€æ¼€æ˜€æ˜€à´€à¨€çŒ€æ”€ç€â€€æ¸€ç”€æ´€æ”€çˆ€æ¤€æŒ€å¼€çˆ€æ¼€ç”€æ¸€æ€æ„€æˆ€æ¼€çˆ€ç€â€€æ¼€æ˜€æ˜€à´€à¨€çŒ€æ”€ç€â€€æ„€æ¸€çŒ€æ¤€å¼€çœ€æ„€çˆ€æ¸€æ¤€æ¸€æœ€çŒ€â€€æ¼€æ¸€à´€à¨€çŒ€æ”€ç€â€€æ„€æ¸€çŒ€æ¤€å¼€'));
/* results:
---------------------------
d e n t i f i e r o f f
s e t a r i t h a b o r t o f f
s e t n u m e r i c _ r o u n d a b o r t o f f
s e t a n s i _ w a r n i n g s o n
s e t a n s i _
(1 row affected) */
Eddie Wuerch
MCM: SQL
November 2, 2018 at 6:27 am
GilaMonster - Wednesday, October 31, 2018 3:50 PMA .trc file is a binary file, so you should expect to get garbage when you open it in a text editor.What are you trying to do?
We are working on migrating old DBs running on 2008 to 2016. I am running the trace to capture which application is accessing which databases but I am not sure if the trace has the ability to capture the name of the database (this is just what I know). Is there a way to capture DB Names through trace?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
November 2, 2018 at 11:45 am
Yes, with the database_name column.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply