We have two identical SQL Server 2005 databases, both on the same server. One is for operational use and the other is for testing purposes. The test database was created using the SQL Server Management Studio Tasks | Copy Database option. When our VB .NET application uses the operational database, the reports are produced within a few seconds. When we use the test database, the reports take several minutes. We've checked the connection strings and they are identical, except for the name of the database.
Does anyone have any ideas of why the test database would be so slow?