We recently upgraded a report server and corresponding reports from SQL Server 2000 (reports 2003) to SQL Server 2005. After upgrade one of our reports which use two subreport is very very slow.
The sp's used for these all these reports are fast. All the sp's together takes about 40 secs.
Both in the BIDS environment as well as the report site the report is very slow.
We are using a database in which data is inserted through replicatoin. In all our sp's we have given 'with nolock' along with the table names.
Can anyone please help me here?
View Complete Post