Can't remember an Error 500 with SSMS.

Do you have an obfuscated connectionstring? What kind of authentication are you using? SQL / Windows / ...

Is the server currently waiting on memory?

https://erikdarlingdata.com/signs-you-need-more-memory-in-your-sql-server/

https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

As Ken mentioned CX_PAKKET got subdived in CXSYNC_PORT en CXSYNC_CONSUMER . Related to parallellism. Have you set a maxdop?

Catch up with the latest CU 7 for SQL 2022 https://www.microsoft.com/en-us/download/details.aspx?id=105013

Have you...

Whilst installing a new laptop, noted that the download link for sql 2019 developer has disappeared

It's getting popular to rename brands

• Twitter to X
• Azure AD to Entra https://techcommunity.microsoft.com/t5/microsoft-entra-azure-ad-blog/azure-ad-is-becoming-microsoft-entra-id/ba-p/2520436

I agree with Grant. Thought that datacollector was obsolete.

A monitoring tool or DIY .

For DIY you may experiment with dbatools powershell module.

Thanks for the suggestions, but the dataset was too small. An expanded version generates too much nulls.

Got a sufficient solution working posted below.

Better dataset:

DROP TABLE IF EXISTS...

Thanks Drew, Jeff for highlighting the alternative with DENSE_RANK. Interesting way to handle or exists

*edit *

• This reply was modified 2 years, 4 months ago by Jo Pattyn. Reason: Possbile wrong answer

Checkout https://www.sqlservercentral.com/blogs/how-to-get-live-execution-plan-using-extended-events

MS documentation on it https://learn.microsoft.com/en-us/sql/relational-databases/performance/query-profiling-infrastructure?view=sql-server-ver16

You can capture blocking with extended events on SQL 2019, but doesn't have alerting

Alerting can be done with xesmarttarget

https://spaghettidba.com/2022/02/28/recipe-5-killing-blocking-spids/

https://spaghettidba.com/2022/02/25/recipe-4-sending-alerts-via-email/

Is it possible to have an sql-script posted as code to reproduce your question so we don't have to open a possible dangerous excelfile

We update short support documentation when we are on supportduty. Usually by another person than who wrote the program

It's necessary to support the number of applications, can't know it all...

Page_latchup is mentioned in https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-wait-stats-transact-sql?view=sql-server-ver16

Can you post the matching DDL? Can you view the query plan?

Are there good indexes on c_b_party_comm

You can start by watching  https://www.brentozar.com/training/think-like-sql-server-engine/ series