Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replaing profiler

Status
Not open for further replies.
Mar 29, 2004
120
US
This is probably a dumb question, but I gatta make sure, never done it before.

When replaying the Profier, do all the transactions ACTUALLY get performed on the database (inserts, deletes, etc)?

Thanks
 
No, they don't. As far as I know, the Profiler replay just shows you what happened when.

No one has ever complained to me about duplicate transactions before, anyway. Of course, I've only used it once or twice in a replay situation.







Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???
 
Profiler is like a tape-recorder. You talk into a tape-recorder and then play it back. When you play it back it doesn't make you say the words again.

-SQLBill

Posting advice: FAQ481-4875
 
OK, I want to look at the system performance during the replay (CPU, HDD, SQL counters, etc.) I will still be able to do that, right?

Even though Profiler doesn't apply changes (like applying logs), it'll still rev up the CPU, right?

Thanks
 
Yes, it'll still take up some processor space. Every program does. I'm not so sure that the CPU use (via Task Manager) will be the same this time around as it was when you recorded your Profiler session, though. If you need CPU #s, etc, I'd go to Performance Monitor (under Administrative Tools which may or may not be hidden in Control Panel) which is the Windows event & system tracer. Record CPU, Memory, etc. in a trace there and then check it.

And anything you recorded during your trace should be there, so you should also be able to see what you saw the first time around.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???
 
FYI, just found this in Itzik Ben-Gan's article:


"Note that a replay doesn't simulate captured events; it re-executes them. So when you replay a trace, you'll likely modify your database. For example, if you replay a trace that includes an INSERT operation, you might find a table with a duplicate key. To keep this problem from happening, revert your database to its initial state if you're replaying the trace against the source server (the server on which you originally traced the events)."
 
Wow. Just looked up Replaying Traces in the Index help file on Profiler. The help file doesn't say so in so many words (and could definately be misinterpreted because of it) but it looks indeed like this is so.

It also lists a way of replaying the Trace against a different DB. If you have a backup of this db, I would restore it with a different name and replay the trace against that DB then.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top