sql express最大利用1GB内存。 [英] sql express maximum utilise 1GB of memory.

问题描述

嗨朋友们，

我有疑问。我搜索了sql express版本。它可以最大限度地利用1GB的内存。它是什么意思？如果它超过1GB，会发生什么？它适用于整个sql server还是sql server的每个用户？如果我建议客户为人力资源管理系统的网络应用程序提供快递版本会不会出现问题。并发用户数量有限制吗？



George

Hi Friends,
I have a doubt.I had searched about sql express edition.It can maximum utilise 1GB of memory .what does it mean?If it exceed 1gb ,what will happen? Is it for entire sql server or per user of sql server? Will it make a problem if I suggest express edition for a web application of HRMS for customer .Is there any limitation in the number of concurrent users?

George

推荐答案

1GB限制是每个SQL Server Express实例。每个实例都可以支持多个数据库和多个用户。



现在，这并不意味着当你打开任务管理器并看到他的工作集爬升到1GB时就会出现问题。将要发生。您将看到SQL Server的内存超过1GB并且可以大大超过1GB。



SQL Server有各种各样的缓存和存储。 1GB限制仅适用于一件事，缓冲区缓存 [ ^ ] 。



超过1GB限制时会发生什么？我不知道。我甚至都没有在SQL Express上接近它。

The 1GB limit is per instance of SQL Server Express. Each instance can support multiple databases and multiple users.

Now, that does NOT mean that when you open Task Manager and see he Working Set creeping up to 1GB something bad is going to happen. You'll see the memory for SQL Server exceed 1GB and can go much, much higher than 1GB.

SQL Server has hundreds of caches and stores for various things. The 1GB limit only applies to one thing, the buffer cache[^].

What happens when the 1GB limit is exceeded? I have no idea. I've never even come close to exceeding it on SQL Express.

这篇关于sql express最大利用1GB内存。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！