mysql - SQL Server 2005 32 位 - 错误 : The OLE DB provider "OLEDB.1" for linked server "(null)" reported an error. 提供程序内存不足

Question

最近我注意到我的一些工作因上述错误而失败。当我用谷歌搜索时，发现了下面的文章 - https://www.johnsansom.com/sql-server-memory-configuration-determining-memtoleave-settings/

WITH VAS_Summary AS
(
    SELECT Size = VAS_Dump.Size,
    Reserved = SUM(CASE(CONVERT(INT, VAS_Dump.Base) ^ 0) WHEN 0 THEN 0 ELSE 1 END),
    Free = SUM(CASE(CONVERT(INT, VAS_Dump.Base) ^ 0) WHEN 0 THEN 1 ELSE 0 END)
    FROM
    (
        SELECT CONVERT(VARBINARY, SUM(region_size_in_bytes)) [Size],
            region_allocation_base_address [Base]
            FROM sys.dm_os_virtual_address_dump
        WHERE region_allocation_base_address <> 0
        GROUP BY region_allocation_base_address
        UNION
        SELECT
            CONVERT(VARBINARY, region_size_in_bytes) [Size],
            region_allocation_base_address [Base]
        FROM sys.dm_os_virtual_address_dump
        WHERE region_allocation_base_address = 0x0 ) AS VAS_Dump
        GROUP BY Size
    )
SELECT
    SUM(CONVERT(BIGINT, Size) * Free) / 1024 AS [Total avail mem, KB],
    CAST(MAX(Size) AS BIGINT) / 1024 AS [Max free size, KB]
FROM VAS_Summary WHERE FREE <> 0

我从 mySQL 得到了以下结果

总可用内存，KB ||最大可用大小，KB69448 || 3264

这篇文章介绍了 VAS 内存，我不确定这是否与 VAS 内存有关？如果是这样我该如何清除或增加它？我不是专业水平，这只是第一次看到这个并进入服务器内存，请有人帮助我。如果有人能一步一步告诉我方法，对我理解会有好处。谢谢

Answer 1

我已经解决了，感谢下面

http://www.wonderwaremidwest.com/wp-content/uploads/TN1042.pdf