SQL Server高内存使用率 [英] SQL Server High memory usage

问题描述

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

解决方案

在解决您遇到的任何问题之前，您需要升级到支持的服务包。

https://support.microsoft。 com / zh-CN / help / 321185 / how-to-determination-the-version-edition-update-level-of-sql-server-an

SQL Server使用服务器上所有可用内存是完全正常且预期的行为。 这并不表示存在问题。

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options ？view = sql-server-2014

你究竟遇到了什么问题？

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

解决方案

Before pursing any problem you are having, you need to upgrade to a supported service pack.

https://support.microsoft.com/en-us/help/321185/how-to-determine-the-version-edition-and-update-level-of-sql-server-an

It is completely normal and expected behavior for SQL Server to use all available RAM on the server.  This not an indication of a problem.

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-2014

What exactly is the problem you are having?

这篇关于SQL Server高内存使用率的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！