CODEWITHSUNDEEP
sqlsql-server-2016
Mehmet Otkun
Mehmet Otkun

Reputation: 1384

SQL Server 2016 RESERVED_MEMORY_ALLOCATION_EXT

I have a SQL Server 2016 Standard Version and often face with 

RESERVED_MEMORY_ALLOCATION_EXT
SOS_SCHEDULER_YIELD
MEMORY_ALLOCATION_EXT

wait types. However my server CPU don't exceed 20% and I have always 75 GB freeable memory?

I set MAXDOP value 3 but there is no change. I didn't face with any problem when I was using Enterprise edition with same DB and same queries.

Thank you for help

Upvotes: 0

Views: 2160

Answers (1)

Georg
Georg

Reputation: 183

We exerienced the same today and it was due to a virtualization issue. We had another VM on the same physical host which ran at 100% CPU and due to overcommitment and missing reservation, the Database VM had to wait for CPU cycles. This is almost impossible to track down from within the Database VM.

Upvotes: 1

Related Questions