Testing the performance of the new SQL Server is troublesome. There is a tool (SQL Server rml) that can be used to replay another instance of the tracking file for SQL Server, so as to evaluate the performance of the new server. In addition, SQL Server rml is useful ProgramYou can also perform the following tasks:
- You can determine the application, database, SQL Server login name, or query with the most resources.
- You can determine whether to change the captured batch trace to a batch execution plan. In addition, you can use the SQL Server rml utility to determine how SQL Server executes each of these execution plans.
- You can make sure that the running query is slower than the previous one.
After the instance's SQL Server capture Trace, you can use the SQL Server rml utility to replay the trace file against another instance of SQL Server. If you can capture a trail during replay, you can use the SQL server of the rml utility to compare it with the original trace file. This technique can be used to test the modified behavior of the SQL server application.
: Http://www.microsoft.com/en-us/download/details.aspx? Id = 8161