September 30, 2008 at 12:45 am
Hi Folks,
I am just shooting from the hip here but if you are migrating a database from sql 2000 to 2005 and you wanted to test the migration would it be possible/useful to run a trace on the sql 2000 box through profiler and then replaying the trace on the 2005 sql server to see if the queries run against the 2005 box ok?
September 30, 2008 at 1:00 am
Never tried it but you can use profiler to capture the queries and then replay them (tsql_replay template), this would give an indication of how the migrated system works with the workload captured in the trace.
September 30, 2008 at 8:16 am
Actually you can and do it very effectively IF certain conditions are met.
If you want detailed information I recommend you contact the folks at http://www.SQLRx.com. Here is a basic outline. This assumes you have a Test/Dev set up for your existing 2000 database.
1. take a baseline full backup of the source system.
2. Start Profiler on the the Source System using the Replay Template and make a "Replay Trace".
3. Run you regression, performance, or other bench marking tests.
4. Stop Profiler and save the trace.
5. Restore the baseline Source full backup on the Target system
6. Start an instance of Profiler on the target system using a monitoring template (I have a custom template but the "Standard" will do).
7. Start an instance of Profiler on the target and Replay the "Replay Trace".
The target monitor trace will give you details on exection (reads, writes, duration, etc.) depending on what you traced. You can compare the results to your baseline from the source to see what changes.
Now some caveats.
1. The DBId of the database on the source and target have to be the same (or you have to edit the replay trace).
2. The replay trace is played back as fast as Profiler can. So you can get a good idea of how individual queries will be affected but not so much about how the overall system will be affected.
3. If your application accesses multiple databases, mine uses 16 🙁 the coordination and synchronization issues are not worth the effort.
Hope this helps.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply