大网数据广告活动
数据库与应用安全

Interoperability issues between batch mode processing and large page memory model

· 52CE 我爱测

Learn to resolve the performance and stability issues that that arise from the use of batch mode processing on columnstore and rowstore with large page memory model in SQL Server.

This article helps you resolve the performance and stability issues that arise from the use of batch mode processing on columnstore and rowstore with large page memory model in SQL Server.

Original product version:   SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, SQL Server 2022
Original KB number:   3210239

Symptoms

In this scenario, you experience one or more of the following issues:

  • A non-yielding Scheduler error and associated memory dumps in the SQL Server Error log.

  • Queries that use batch mode processing may run into severe performance issues.

  • Access violation exceptions and associated memory dumps in the SQL Server Error log.

  • You may see the following error message when you run sp_createstats:

    There is insufficient system memory in resource pool 'default' to run this query
    

Workaround

To mitigate these issues, try either or both of the following two methods:

  • Disable the large page memory model by removing the trace flag 834 (-T834) from SQL Server startup parameters on the SQL Server instance. When you complete this step, SQL Server stops using a large page memory model and reverts to a conventional or lock pages memory model.

  • If you don't use columnstore indexes in your SQL Server and you experience the described symptoms, you can disable batch mode on rowstore at the database level by using ALTER DATABASE SCOPED CONFIGURATION SET BATCH_MODE_ON_ROWSTORE = OFF. For more information, see ALTER DATABASE SCOPED CONFIGURATION.

More information

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 07/05/2023
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。