I have a situation where a report on Production Server takes 2 min 30 secs while on Dev takes 40 secs.
We are on SQL Server 2005 Ent. Edition.
Hardware, Data and configurations are identical. The test is done at 12.00 Midnte to isolate application load on prod from being the reason for difference.
Can you please point me some areas to look into as what is causing the difference.