| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |
|---|---|---|---|---|---|---|---|---|---|---|
MSSQLSERVER_898 |
MSSQLSERVER_898 |
suresh-kandoth |
sureshka |
wiassaf |
02/15/2022 |
sql |
supportability |
reference |
|
[!INCLUDE SQL Server]
| 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. |
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.
This is an informational message, no action is necessary.
This message can be suppressed by TF890. For more information, see TF890.
For more information, see Operations that trigger a buffer pool scan may run slowly on large-memory computers.