For production/test server scenario mentioned earlier, SQL Server 2005 has been enhanced to allow (a) import of statistics and (b) and simulation of hardware characteristics of production server into the test server. These two functionalities are crucial in getting identical recommendations on the production and test servers.