I am getting this error while doing concurrent read from same table through linked server. Time out setting is alright. When this error happens, I also start getting the following error for the same query:
"Transaction (Process ID X) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.."
Does this mean that there is a limitation to the number of reads that can be performed through linked server ? If so, what is the limit ? or could this be happening because of some other reason ?
Also the query used is as follows :
SELECT T.Col1, T.Col2, T.Col3, PG.Col1, PG.Col2, PG.Col3 INTO #TMP_OUTPUT FROM linkedserver1.db1.dbo.table1 T WITH (NOLOCK) INNER JOIN #temp2 PG ON T.Col1 = PG.Col1 WHERE T.Col3 = somevalue