MS-SQL Server - Memory High, Raiserror & Waittype Analysis

Memory High, Raiserror & Waittype Analysis

https://learn.microsoft.com/en-us/answers/questions/584395/high-memory-utilization-of-sql-server-sqlservr-exe

Raiserror

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/raiserror-transact-sql?view=sql-server-ver16

Waittype Analysis

Additionally,

Is CASE..WHEN..THEN sargable ?

https://learn.microsoft.com/en-us/answers/questions/960508/is-case-when-then-sargable

Waittype Analysis

Int. Waittype

QDS_ASYNC_PERSIST_TASK_START

Error 21894

Any query will be considered

T. Amit Vaid S.