Timeline for LATCH_EX and CX_PACKETS for a stored proc seen when timing out
Current License: CC BY-SA 4.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 16, 2021 at 15:15 | history | edited | Aleksey Vitsko | CC BY-SA 4.0 |
added 3 characters in body
|
| Aug 12, 2021 at 15:03 | history | edited | Aleksey Vitsko | CC BY-SA 4.0 |
added 13 characters in body
|
| Aug 11, 2021 at 20:50 | comment | added | Charlieface | For better performance help, you need to give us the full query, table and index definitions, and share the query plan via brentozar.com/pastetheplan. A 15 minute stored procedure sounds excessive anyway | |
| Aug 11, 2021 at 19:02 | comment | added | Newbie-DBA | It accepts datetime parameter for todays date but i think parameter sniffing might not be the issue because just before job runs, database had a fresh restore from LS restore job, so plans might be invalidated | |
| Aug 11, 2021 at 18:59 | comment | added | Newbie-DBA | @AlekseyVitsko: Latch_EX i see is described here -sqlskills.com/help/latches/access_methods_dataset_parent | |
| Aug 11, 2021 at 17:24 | comment | added | Aleksey Vitsko | also you wrote that "wait time showing accumulating upto 8 hours for that 1 hour run" when SP fails, what's wait time for CXPACKET and what's for "LATCH_EX" ? | |
| Aug 11, 2021 at 17:23 | answer | added | Aleksey Vitsko | timeline score: 1 | |
| Aug 11, 2021 at 17:13 | comment | added | Aleksey Vitsko | also, does this SP have any input parameters ? | |
| Aug 11, 2021 at 17:07 | comment | added | Aleksey Vitsko | There is no LATCH_EX wait type, there are PAGELATCH_EX and PAGEIOLATCH_EX. Which one are you having when SP completes/fails ? | |
| Aug 11, 2021 at 16:16 | history | edited | Newbie-DBA | CC BY-SA 4.0 |
added 399 characters in body
|
| Aug 11, 2021 at 13:59 | history | edited | Newbie-DBA | CC BY-SA 4.0 |
added 58 characters in body
|
| Aug 11, 2021 at 5:57 | history | edited | KASQLDBA | CC BY-SA 4.0 |
deleted 1 character in body
|
| Aug 10, 2021 at 16:25 | history | asked | Newbie-DBA | CC BY-SA 4.0 |