Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  SQL Server 2000 replay trace files

Author  Topic  nashmi Starting Member 3 Posts Posted - 2011-12-02 : 14:42:05 Hi I am new bie. I have a test system in which the profiler traces are running and I have access to it. I have a development system with SQL server 2000(a clonning of the production system) and I have to replay the traces in the 2000 server and setup a baseline for comparision and resolve the issues. 1) I have the trace files running in the test system but that test system is just to store data and I have access to the trace files there and I don't have them running in the the SQL server 2000. Do I need to replay the traces in the test only and save it ? Is it possible to replay those traces in the 2000 box ? 2) There are lot of issues with deadlocks and stored procedures. What are all the considerations to check the baseline while running the replay ? If I could get a step by step procedure, it would be of great help. Thanks in advance.