DAC重置max server memory
2024-03-31 17:01:04
15:44 2014-01-24 08R2,一次通过GUI更改'最大服务器内存(MB)'为16MB,errorlog显示信息如下
2014-01-23 15:49:49.71 spid55 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2014-01-23 15:49:49.88 spid55 FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2014-01-23 15:49:49.92 spid55 Configuration option 'max server memory (MB)' changed from 2147483647 to 16. Run the RECONFIGURE statement to install.
2014-01-23 15:49:49.92 spid55 FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2014-01-23 15:49:49.96 spid55 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2014-01-23 15:49:49.99 spid55 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2014-01-23 15:49:49.99 spid55 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2014-01-23 15:49:50.06 spid55 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2014-01-23 15:49:50.06 spid55 FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2014-01-23 15:50:26.37 spid55
Memory Manager KB
---------------------------------------- ----------
VM Reserved 1619672
VM Committed 44800
AWE Allocated 0
Reserved Memory 1024
Reserved Memory In Use 0
2014-01-23 15:50:26.39 spid55
Memory node Id = 0 KB
---------------------------------------- ----------
VM Reserved 1616856
VM Committed 42096
AWE Allocated 0
MultiPage Allocator 14312
SinglePage Allocator 15944
2014-01-23 15:50:26.40 spid55
Memory node Id = 32 KB
---------------------------------------- ----------
VM Reserved 1728
VM Committed 1672
AWE Allocated 0
MultiPage Allocator 1600
SinglePage Allocator 15944
2014-01-23 15:50:26.40 spid55
MEMORYCLERK_SQLGENERAL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 1216
MultiPage Allocator 3528
2014-01-23 15:50:26.39 Server Failed allocate pages: FAIL_PAGE_ALLOCATION 1
执行查询语句报错
2014-01-23 16:47:08.80 spid54 错误: 701，严重性: 17，状态: 130。
2014-01-23 16:47:08.80 spid54 There is insufficient system memory in resource pool 'default' to run this query.
2014-01-23 16:47:08.80 spid55 错误: 701，严重性: 17，状态: 123。
2014-01-23 16:47:08.80 spid55 There is insufficient system memory in resource pool 'default' to run this query.
第二天在对象资源管理器下连接数据库报错(重启过)--08下想重现错误，没能成功
通过DAC连接重置max server memory，重启数据库服务，正常登录
sqlcmd -E -S 127.0.0.1,1434
sp_configure 'show advanced options',1
go
reconfigure with override
go
sp_configure 'max server memory',1024
go
reconfigure with override
go
--附DAC连接
1、单用户模式启动数据库
开启一个命令窗口，输入以下命令，并保持窗口打开
d:
cd D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn
sqlservr.exe mssqlserver -m
查看返回的日志信息，找到类似下面两行
Server is listening on [ 127.0.0.1 <ipv4> 1434] .
Dedicated admin connection support was established for listening locally on port 1434.
2、使用DAC连接到数据库
在另一个命令窗口运行
sqlcmd -A -d master
sqlcmd -E -S 127.0.0.1,1434或
sqlcmd -Usa -Ppassword -S 127.0.0.1,1434
最新文章
- JVM的GC概述
- 1、Flat UI Getting started（文档翻译）
- 展讯DTS路径及编译
- asp.net导出Excel 按照预定格式，以及解决导出乱码
- JavaScript入门(5)
- C#用正则表达式 获取网页源代码标签的属性或值
- x86_64是什么意思
- CSS-学习笔记六
- SQL Server 日志和代理的错误日志
- Redis 安装学习
- 学习ML.NET(2): 使用模型进行预测
- php 的函数
- laravel架构
- 《算法》第六章部分程序 part 5
- 使用__all__限制模块可被导入对象
- codeforces 484a//Bits// Codeforces Round #276(Div. 1)
- python---CMDB配置管理数据库
- DAGDGC特殊调弦
- 关于TOSCA自动化测试工具， 我想问一些问题（持续整理中）
- js实现无限级分类