Buffer Pool wait high

Question

Is it means need add more RAM?

Thanks

Sky

Answer 1

Thanks for your question.

In Azure SQL Database, the "buffer pool" wait type indicates that a worker thread is waiting for a page to be loaded into the buffer pool memory cache.

It's important to monitor the buffer pool wait type to ensure that the buffer pool is large enough to store frequently used data and to prevent excessive disk I/O.

If you see a high number of buffer pool waits, you may need to increase the size of the buffer pool by adjusting the Azure SQL Database's resource limits.

Or if you are facing performance issue, you may need to optimize your queries to reduce the amount of data that needs to be read or written.

And also need to check index (fragmentation) or use appropriate index in the queries to improve query performance.

Answer 2

If you don't have a performance issue, you can sit on your hands.

Then again, it may be an early warning. After all 16 GB of RAM is not a whole lot. But I don't know how big the database is and which edition you have.