adjust trace replay speed

Posted on 2004-10-27
Medium Priority
Last Modified: 2008-03-06
Is it possible in SQL2k Standard to adjust the speed of a trace replay in Profiler. By default it appears as though it will just run as quickly as possible and I need it to run in the tme it actually ran when captured.
Question by:rseraji
1 Comment

Accepted Solution

pedros7 earned 1500 total points
ID: 12431371
According to microsoft:

Replay Events In The Order They Were Traced Events are started in the order in which they originally started. This enables debugging but doesn't guarantee timing of event execution. Events may be executed sooner than their original start time or after their original start time, depending on current activity levels, the current speed of connections, and other factors.
Replay Events Using Multiple Threads Events are replayed as quickly as they can be processed. No timing is maintained between events. When one event completes, the next event is started. This optimizes performance and disables debugging.

The Display Replay Results check box controls whether the replay results are displayed in the Profiler window. To display results, select this option. Otherwise, clear this option.

You can also select an output file to save the result of the replay for later viewing. The output file allows you to review the replay just as you would any other trace file.

Read more at: http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c10ppcsq.mspx

HTH :)

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
What we learned in Webroot's webinar on multi-vector protection.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question