Performance issue with Linked server in UAT environment, but same SQL when run from DEV server performs fine with the Linked server
Posted on 2008-10-23
Application: Has linked servers to a SQL server and an Oracle server.
Recently a release was moved from DEV to UAT. A job which runs for 10mins in DEV is taking 90mins in UAT.
We isolated the problem to 2 SQL statements, but these statements run fine in DEV, which is also pointing to the same SQL linked server.
The JOB prior to release in UAT used to run in 10mins time. After the release the job is taking 90mins, but the same job runs in 10mins in DEV
Any pointers, I the problem SQL in the job has been identified to be SELECT statements from a VIEW, which in turn points to other views mapped out of the linked server(SQL).
But the same peice of code just runs fine in DEV??? puzzled.