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?
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.