701: There is insufficient system memory in resource pool to run this query(资源池中的系统内存不足,无法运行此查询)
SQL Server含义
SQL Server 无法从相关资源池分配运行查询所需的内存。操作因内存压力而失败。
原因
服务器内存不足、max server memory 设置过低、消耗大量内存的查询(大型排序/哈希)、内存泄漏、大量并发请求,或 Resource Governor 池限制。
解决方法
检查 max server memory 设置并提供足够的物理 RAM。优化消耗大量内存的查询(合适的索引、更少的排序/哈希)。监控内存:sys.dm_os_memory_clerks、DBCC MEMORYSTATUS、Perfmon 内存计数器。调整 Resource Governor 池限制。必要时降低并发度。
同一数据库的其他条目
- 233A connection was successfully established with the server, but then an error occurred (no process is on the other end of the pipe)(已成功与服务器建立连接,但随后发生错误(管道的另一端上无任何进程))
- 823The operating system returned error to SQL Server during a read/write at offset in file (I/O error)(操作系统在文件的偏移量处读/写时向 SQL Server 返回了错误(I/O 错误))
- 824SQL Server detected a logical consistency-based I/O error (page corruption)(SQL Server 检测到基于逻辑一致性的 I/O 错误(页损坏))
- 845Time-out occurred while waiting for buffer latch(等待缓冲区闩锁时超时)
- 3201Cannot open backup device. Operating system error (backup device error)(无法打开备份设备。操作系统错误(备份设备错误))
- 8134Divide by zero error encountered(遇到以零作除数错误)
- 245Conversion failed when converting the value to data type(将值转换为数据类型时失败)