MSSQLSERVER_802
Details
Product Name |
SQL Server |
Product Version |
10.0 |
Product Build Number |
10.00.0000.00 |
Event ID |
802 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
NO_BUFS |
Message Text |
There is insufficient memory available in the buffer pool. |
Explanation
This is caused when the buffer pool is full and the buffer pool can not grow any larger. This error does not necessarily indicate an out-of-memory condition. It might indicate that the buffer pool memory is used by someone else.
User Action
For general memory troubleshooting actions, see MSSQLSERVER_701. For more information about troubleshooting memory problems, see Troubleshooting Performance Problems in SQL Server 2008 on MSDN.