Use this page of the SQL Server Upgrade Assistant UI to specify the trace file to replay against SQL Server Code Name “Denali” and the trace output file. The trace file is the trace file you created from SQL Server 2005/2008. The trace output file will contain the results of the replayed trace file.
If you are using multiple computers for the test, perform this step on the upgraded test server. For more information, see Create a Multiple-Computer Test Environment.
Specify the name of the SQL Server Code Name “Denali” server and instance where the trace will be replayed. By default this field contains the name of the local computer. To replay the trace to a different server, specify the server name. For a named instance, specify servername\instancename.
Specify the type of connection to use to replay the trace. Windows Authentication is specified by default. If you specify SQL Server Authentication, enter the User name and Password for a SQL Server account that has permission to replay a trace on the server.
Specify the full path of the trace file.
Note: If you used Upgrade Assistant to capture a playback, the trace file is in the folder you specified as the Playback capture location. Click Browse to locate the directory, or type the full path.
Specify the full path to store the results of the replay. By default, this is the log folder where Upgrade Assistant is stored. Pay attention to the path and name of your output file and make sure there is no other file with the same name. You will need this file later for analysis.
Replay the playback trace file. This button is enabled when Server name, Authentication, Playback trace file, and Trace output file are specified.
Displays each event as it is replayed.
Displays the status of the replay as it progresses.
Displays the query that is currently being replayed.
Figure 5 below is a sample screenshot of the TEST trace replay page for the SQL Server Code Name “Denali” playback.
Figure 5 . Test Trace Replay