When you test possible solutions to a performance problem, use SQL Server Profiler to replay Transact-SQL scripts, and compare performance before and after your changes.
To replay a Transact-SQL script
On the File menu, point to Open, and then click Script File.
Select the Transact-SQL script file you want to open. Make sure that the Transact-SQL script contains events necessary for replay. For more information, see Replay Requirements.
On the Replay menu, click Start, and connect to the server where you want to replay the script.
In the Replay Configuration dialog box, verify the settings, and then click OK.