|
Comments
|
|
Excellent
|
|
|
Awesome.
|
|
|
Thanks a lot :L
|
|
|
Great information.
|
|
|
I know with only 2 minutes time you don't have a lot of time to discuss issue related to replay. Just wondering what kind of requirements might there be on replaying a trace, especially if the trace updates the database, or the database has been significately update since the trace file was captured.
|
|
|
At the end of video, an explanation why there where total 39 events but only 21 replayed would be good. This was not explained, and left me with questions
|
|
|
What is the purpose of replaying a trace file?
Can you just replay a trace file whitout harming the production database on which the trace was made?
|
|
|
How about linking to related videos? Because i don't know how to get to that trace properties box that was displayed, I'm a newbie with the tool but a SQL, I'd like to learn as much as possible.
|
|
|
Suppose during the initial trace that there were queries that did inserts, updates, and/or deletes. Does replaying the trace cause those statements to be re-executed? Is replaying only useful when all the queries were selects?
|
|
|
Great comments folks. I'll answer the questions in separate comments.
|
|
|
Greg\Patrick\B.A.,
Great questions, I appreciate them. When replaying a trace you do not want to do it against Production database as it truly replays the actions, it does not simulate the actions.
|
|
|
Lisa,
Good idea. There are several other Profiler videos on JumpstartTV. You can find many of them by clicking on my name to see my profile, which lists all the videos I have done. Or, you can do a search for Profiler. I am sure the site owners\developers will see your comment and consider adding a related videos section
|
|
David Lundell on
5/27/2009
You should mention why one wants to replay a trace and any sideeffects
|
|
|
Great!!
|
|
|
excellent
|
|
|
I'd be interested to see a video of the different ways a replayed trace can be used to troubleshoot...problems, I guess.
|
|
|
a bit more information on what sort of traces you can run, eg what happend with errors etc.
|
|
|
OK
|
|
|
If the replay creates records or tables, will it create duplicates?
|
|
|
It would be nice to know if replaying a trace actually executes the same statements against the same server...resulting in the exact same demand/load on the server.
In a highly transaction environment, it would not be wise to replay a trace during a busy time of the day if it would bring the server to its knees so-to-speak
|
|
|
This was a very simple replay and multiple threads were not used. I was interested in a more advanced replay since i typically see a lot of errors when replaying a trace on my systems.
|
|
|
okk
|
|
|
Thanks Jack: quick and helpful.
|
|
|
Short, quick and informative video.. Thanks a lot.
|
|
Maurice Ivory on
2/13/2012
Not bad...good things to know about TSQL
|
|
|
Short and sweet. Right to the point. Highly recommended watch.
|