• How about slowly running queries? Would there be any problems caused due to memory paging or something of that sort? I did do the trace using profiler and have attached a zip file containing the output (XDL file) in my main problem dialog.

    To explain a little more, we have a database A where daily updates and insertion of records happen. Then in the evening, the database is taken offline and copied over as Database B. This particular database does not have any activity happening in it other than BO reports.

    Wait a minute, does having the logical name of Database B same as the Database A create an issue?