问题描述
HI先生,
由于内存使用率过高,数据库连接丢失并发生故障转移。
操作系统:Windwos服务器2012
SQL Server版本:Windows NT 6.2上的SQL Server 2014 - 12.0.2548.0(X64)企业版(64位)< X64> (构建9200:)(管理程序)
总物理内存:311286MB
数据库大小:180 GB
CPU:30-60%
内存使用率:95%至97%
INSTANCE 1:
最小内存:0
最大内存:2147483647 MB
请建议如何 最小内存和最大内存以上配置设置
baskarlakshmi
HI sir,
Due to high memory usage database connection lost errors occurring and fail-over happening.
OS: Windwos server 2012
SQL Server version: SQL Server 2014 - 12.0.2548.0 (X64) Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
Total physical memory: 311286MB
Database Size: 180 GB
CPU: 30- 60%
Memory usage: 95 TO 97%
INSTANCE 1:
Min Memory: 0
Max Memory:2147483647 MB
please suggest how to min memory and max memory the above configure settings
baskarlakshmi
这篇关于SQL Server高内存使用率的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!