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 3.2 Create a Multiple Computer Test Environment

Server name

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.

Authentication

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.

Playback trace file

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.

Trace output file

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 Trace

Replay the playback trace file. This button is enabled when Server name, Authentication, Playback trace file, and Trace output file are specified.

Results

Displays each event as it is replayed.

Status

Displays the status of the replay as it progresses.

Query

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

You now have replay trace from before and after the upgrade.  You can now compare them to see what changed in the upgrade.  10.0 Compare Trace Files