When I run my query from DW, which uses a linked server, it times out. I then take that query, run directly on a linked server with select top 1 and it takes 85 minutes.
Now I restore the linked server DB in test. I run the same query from test DW and it takes 3 seconds. SO the data is same, query is the same so I am guessing prod stats are out of date? What else could be the reason for it?
Just trying to learn the art of troubleshooting and where to even start from.
Any help is highly appreciated
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]