research Question

SQL query blockers when SQL server is running out of RAM.

Avatar of marrowyung
marrowyung asked on
Microsoft SQL Server
40 Comments2 Solutions44 ViewsLast Modified:

hi all,


right now we have a SQL server 2016 always run into some trouble that some query always the query blockers.


Our SQL server 2016 is standard edition and no money to use enterprise edition, any URL shows that SQL server 2016 standard when do not have enough RAM (by looking at target memory and total server memory) for SQL server operation (MAX hard limit is 128GB of RAM) can cause more SQL query to be the blocker head?


Another option in our head is to use fast SSD SAN as the buffer pool extension to extend the RAM limit.


Please share valid URL say using SQL 2016 enterprise for more RAM support can help on SQL query blockers elimination?




ASKER CERTIFIED SOLUTION
DBAduck - Ben Miller
SQL Server Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 40 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 40 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros