MSSQLSERVER_898
Applies to: 
SQL Server
Details
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| Event ID | 898 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | BPOOL_SCAN_LONG_DURATION |
| Message Text | Buffer Pool scan took %I64d seconds: database ID %d, command '%ls', operation '%ls', scanned buffers %I64d, total iterated buffers %I64d, wait time %I64d ms. See 'https://go.microsoft.com/fwlink/?linkid=2132602' for more information. |
Explanation
Certain operations in Microsoft SQL Server trigger a scan of the buffer pool (the cache that stores database pages in memory). On systems that have a large amount of RAM (1 TB of memory or greater), scanning the buffer pool may take a long time. This slows down the operation that triggered the scan.
User action
This is an informational message, no action is necessary.
This message can be suppressed by TF890. For more information, see TF890.
More information
For more information, see Operations that trigger a buffer pool scan may run slowly on large-memory computers.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for