Timeline for Thousands of After Insert and Update Triggers Causing Performance Issues
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 28, 2021 at 2:49 | comment | added | J.D. | @Vaccano Absolutely, glad to be of help! Best of luck! 🙂 | |
| Apr 28, 2021 at 2:11 | vote | accept | Vaccano | ||
| Apr 28, 2021 at 2:11 | comment | added | Vaccano | Thank you for the tips and information! It was helpful in figuring out what was going on! | |
| Apr 28, 2021 at 1:43 | comment | added | J.D. | ...process / web service, or even potentially at the point of insertion into RabbitMQ by their own governance (though I'd find that unlikely given that RabbitMQ is supposed to be able to handle queuing large amounts of data). | |
| Apr 28, 2021 at 1:42 | comment | added | J.D. |
@Vaccano Interesting, yea so that would fall more into the latter of my two guesses of what you got going on. You should see multiple processes for the CLR Stored Procedure running too though with sp_WhoIsActive. If you don't see the CLR processes running, then I'd assume even that part is done. Not sure what code your CLR is doing but if it's executing something either asynchronously or external like a web service to hit RabbitMQ, then likely at this point your data is already outside the domain of your SQL Server Instance and the trickling is occuring via that outside...
|
|
| Apr 28, 2021 at 0:01 | comment | added | Vaccano |
Thank you for the information. sp_WhoIsActive shows that the insert statement is done. (And a query shows that the data is all there.) That trigger calls a SQL CLR stored procedure. We are still getting data sent by that CLR Sproc to RabbitMQ. I am guessing that there is some buffering process where that sproc has queued the calls and is working through them. (Though really, I have no idea what could be causing what I am seeing.) I am finding it hard to get any kind of metrics on the SQL CLR Sproc.
|
|
| Apr 27, 2021 at 21:18 | history | edited | J.D. | CC BY-SA 4.0 |
added 277 characters in body
|
| Apr 27, 2021 at 21:08 | history | answered | J.D. | CC BY-SA 4.0 |