There is insufficient system memory to run this query 错误
服务器环境大致情况如下 : 操作系统: Microsoft Windows Server 2003 R2 Enterprise Edition Service Pack 2 数据库 : Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) 。 机器物理内存8G,开启了使用AWE分配内存选项(U)" 在这台服务器上,创建You
服务器环境大致情况如下:
操作系统: Microsoft Windows Server 2003 R2 Enterprise Edition Service Pack 2
数据库 : Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) 。
机器物理内存8G,开启了“使用AWE分配内存选项(U)"
在这台服务器上,创建YourSQLDba后,配置过程中创建函数的时候,报如下错误,重试了几次都是如此,但是其它应用从来没有出过这个错误,而且这是一台生产服务器,很多应用在跑,所以这才是让我纳闷的地方:
消息 701,级别 17,香港虚拟主机,香港服务器,状态 13,过程 clr_GetFolderList,第 1 行
There is insufficient system memory to run this query.
消息 701,级别 17,状态 13,过程 clr_GetFolderListDetailed,第 1 行
There is insufficient system memory to run this query.
其实这两个函数也没特别之处,而且在其它64数据库上,也没有碰到过类似的错误。
CREATE FUNCTION yUtl.clr_GetFolderList (@FolderPath nvarchar(4000), @SearchPattern nvarchar(4000))
RETURNS TABLE ([FileName] nvarchar(255))
AS EXTERNAL NAME [YourSqlDba_ClrFileOp].[Clr_FileOperations.FileOpCs].[Clr_GetFolderList];
GO
CREATE FUNCTION yUtl.clr_GetFolderListDetailed (@FolderPath nvarchar(4000), @SearchPattern nvarchar(4000))
RETURNS TABLE ([FileName] nvarchar(255), [FileExtension] nvarchar(255), [Size] bigint, [ModifiedDate] datetime, [CreatedDate] datetime)
AS EXTERNAL NAME [YourSqlDba_ClrFileOp].[Clr_FileOperations.FileOpCs].[Clr_GetFolderListDetailed];
GO
网上搜索了一下,发现蛮多人也遇到个这个错误:,但是也没有一个定论。
于是也按那些人讨论的,检查服务器环境:物理内存,数据库版本,免备案空间,AWE是否开启,最大服务器内存,clr enabled 配置等等
sp_configure 'clr enabled'
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
clr enabled 0 1 1 1
但是,折腾了很长时间,也没搞清真正的出错原因,没办法,只能祭出大杀器”重启SQL SERVER服务",然后重新创建YourSQLDba数据库,创建相关存储过程、函数等。暂时记录一下这个问题,等有空闲或下次遇到时候,再想想办法解决它。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Java document interpretation: Usage analysis of the currentTimeMillis() method of the System class, specific code examples are required. In Java programming, the System class is a very important class, which encapsulates some properties and operations related to the system. Among them, the currentTimeMillis method is a very commonly used method in the System class. This article will explain the method in detail and provide code examples. 1. Overview of currentTimeMillis method

The win10 system is a very easy-to-use and highly intelligent system. Its strong compatibility can ensure that the system will basically not have any problems during normal use. However, as people continue to use the win10 system, sometimes the system will also have problems. The problem of Win10 booting blue screen termination code SystemServiceException. Today I will bring you the solution to Win10 booting Blue Screen termination code SystemServiceException. If you need it, please download it quickly. Solution to win10systemserviceexception blue screen: Method 1: 1. Use Windows key + R to open Run and enter “contr

The computer system is a relatively common system process. You will often see system when viewing the process. This process simply means the computer system; however, if the system.exe process appears on the computer, it needs to be deleted in time. , this is a file generated by a Trojan horse virus. There is no exe suffix behind the real system.

Microsoft has announced the availability of System Center 2022. The latest version brings System Center Operations Manager (SCOM), Virtual Machine Manager (VMM), System Center Orchestrator (SCORCH), Service Manager (SM) and Data Protection Manager

Step back in time to the Macintosh of the 1990s and run complete virtual installations of System 7 and MacOS 8 in a browser window. One flaw with new virtual versions of 1990s Mac software is that they run at the speed of a 2020s Mac. You're looking at a MacSE/30 or Quadra700, but everything is as fast as Apple Silicon. You can actually work in these simulated operating systems, and they can even drag documents or files in and out of macOS Monterey. But whether for some practical purposes or more likely just for pure fun, here's how

Object is the base class of all Java classes, the top of the entire class inheritance structure, and the most abstract class. Everyone uses toString(), equals(), hashCode(), wait(), notify(), getClass() and other methods every day. Maybe they don’t realize that they are methods of Object, and they don’t look at what other methods Object has. And think about why these methods should be placed in Object. 1. Introduction to JavaObject class - the super class of all classes Object is a special class in the Java class library and is also the parent class of all classes. In other words, Java allows any type of object to be assigned to the Object type

I believe that netizens are very familiar with the Windows 7 system. Have you heard of the Windows 7 English version system? I believe that many netizens have heard about the Windows 7 English version system. However, some friends are looking for the Windows 7 English version system to download. Today I will The editor is going to share the introduction of the original version of win7 in English with everyone, so that netizens can understand the original version of win7 in English. The following is to tell you where to download the English version of Windows 7 system. The original English system of win7 has been released to MSDN for subscription download. The official English integrated version was first released, Windows7WithSP1, which is the Windows7 CD image with integrated SP1. Includes SP1 standalone for multiple languages

1. Introduction to System as a system class. In the java.lang package of JDK, it can be seen that it is also a core language feature of Java. The constructor of the System class is decorated with private and is not allowed to be instantiated. Therefore, the methods in the class are also static methods modified by static. The Arrays class in JAVA is a tool class that implements array operations. It includes a variety of static methods that can implement array sorting and search, array comparison, adding elements to arrays, array copying, and converting arrays into String functions. These methods have overloaded methods for all basic types. 2. Detailed explanation of knowledge points 1. The concept is relatively simple introduced in the System class in the API. We give the definition.
