Timeline for SQL Server Linked Server PAGEIOLATCH_SH / CXPACKET
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 17 at 10:02 | history | migrated | from stackoverflow.com (revisions) | ||
| Feb 16 at 18:23 | answer | added | Kevin UI | timeline score: 0 | |
| Feb 16 at 18:03 | comment | added | M Bradley | It is hanging right now but Activity Monitor (linked server) fails to return a plan. | |
| Feb 16 at 2:33 | comment | added | Conor Cunningham MSFT | The query from the "remote" side can't be parallel in the case of a parallel query. However, the remoted query can go parallel. on the remote server. Please review the plan there and see if it is parallel - please post the plan here for more if you have that situation and need help. | |
| Feb 15 at 22:13 | comment | added | Charlieface | Guessing that the query plan went parallel for whatever reason and that plan is slow. Try use Query Store or the plan cache to find the query plan it used (not the one you got in SSMS which might be different). | |
| Feb 15 at 22:10 | history | asked | M Bradley | CC BY-SA 4.0 |