https://www.brentozar.com/pastetheplan/?id=HyUBphZy7 So the developer of this app should really be figuring this out, but it's taking too long and we are suffering from performance issues. I'm nowhere near a dba...i can barely install SQL and run a few queries. Thanks to a friend, I found the ...

I have a log table which receives logs from multiple applications, several inserts per second, approaching ~1M rows per day. The table has a dozen columns (mostly nvarchar), e.g. severity, app name and message, and it also has a clustered ID PK and a few computed columns. One "real" column is JSO...

we came across the following issue that is best described by the image below. To sum up, all (yes, ALL) of the queries this SQL Server was receiving were stuck at RESOURCE_SEMAPHORE and had 0 (NULL) granted memory. Here are the circumstances (these are important to understand the problem): 1) T...