Finding Culprit Blocking Sql Whenever in our system there is a block (everything stopped). I see the below query is the culprit,
  (@P1 numeric(10))SELECT &quot;Col1128&quot;,&quot;Tbl1029&quot;.&quot;A_NAME&quot; &quot;Col1124&quot; FROM &quot;DbName&quot;.&quot;Schema&quot;.&quot;MyTable1&quot; 
&quot;Tbl1029&quot; RIGHT OUTER JOIN (SELECT &quot;Tbl1027&quot;.&quot;MyColumn1&quot; &quot;Col1126&quot;,&quot;Tbl1027&quot;.&quot;MyColumn2&quot; 
&quot;Col1127&quot;,&quot;Tbl1027&quot;.&quot;MyColumn4&quot; &quot;Col1128&quot;,&quot;Tbl1027&quot;.&quot;MyColumn5&quot; &quot;Col1130&quot;,&quot;Tbl1027&quot;.&quot;MyColumn6&quot; 
&quot;Col1129&quot;,&quot;Tbl1027&quot;.&quot;MyColumn5&quot; &quot;Col1131&quot; FROM &quot;DbName&quot;.&quot;Schame&quot;.&quot;MyTable2&quot; &quot;Tbl1027&quot; WHERE 
&quot;Tbl1027&quot;.&quot;MyColumn1&quot;=@P1) Qry1132 ON CONVERT(numeric(2,0),&quot;Tbl1029&quot;.&quot;MyColumn3&quot;,0)=&quot;Col1126&quot;

We have 2 separate DB servers with completely different databases. The above is running in DB server 2 but request is coming DB server 1 (client host name). We have 100 of applications connecting to DB servers. Also, we have link server among DB servers.
Now, I know that the query came form DB server 1 with ProgramName Microsoft SQL Server. Now I am confused whether the program Microsoft SQL Server is indicating the link server query or application query using ORM.
I am searching in all applications but not finding anything yet. Form the DBA perspective what else I can do to get the real issue
Now, I know that the query came form DB server 1 with ProgramName Microsoft SQL Server. Now I am confused whether the program Microsoft SQL Server is indicating the link server query or application query using ORM.

The host name &quot;DB server 1&quot; along with the &quot;Microsoft SQL Server&quot; program name indicates a linked server query, not a query executed directly from the application.

From the DBA perspective what else I can do to get the real issue?

As @Learning_DBAdmin suggested in comments, examine the active queries running on DB server 1 during the blocking episode. One or more should show the query with the linked server along with the originating application host and program name.
The real issue is likely the need for query/index tuning to optimize the remote query. You may need indexes on the join/where clause columns. The explict conversion on Tbl1029.MyColumn3 will preclude using an index on the column efficiently (if one exists). The resultant full scans can lead to blocking.