April 24, 2014 at 3:17 am
We have two databases which have both a Live version and a Report version, the versions are on two separate servers and the stored procedures do not use linked servers.
The stored procedures we have that use both databases are running fine on the live system however when we try to run them from the report system they take forever to complete. Both databases on the report server are restored copies of the live databases that are in Read Only mode and one database is updated every 15 minutes by log shipping.
Does anyone know why we are experiencing such a drop in performance on the Report Server when in theory everything should be the same as the Live Server?
April 24, 2014 at 4:07 am
Sorted, it was the Parallelism setting on the report server which was set differently to the live server
April 24, 2014 at 2:12 pm
Good to hear you have it all figured out. When operating with two different databases like that, another thing to keep an eye on is the statistics.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply