I am not sure if I should post this question in the TSQL forum.
Scenario: There are five databases - db1, db2, db3, db4, db5
In a query i need to access all five databases. I use synonyms. When I run the query in db1, it fetches results in 5 secs. When i run it in say db2, it takes 2 mins. There are a lot of freaky things being done in the query. My question is does it matter which database I am running the query in or was this probably due to load on the database?
I use nolock, readuncommitted query hints as this is for reporting. On testing repetitively, I get random results. Sometimes it fetches me results in ~5 secs in all databases.
I don't know if I have asked the right questions. Any comment will help a lot.