小任班长的博客 -- 查询数据库最大内容使用量
use master
go
select value,* from sys.configurations where name like '%max server memory (MB)%'
go
--下方是修改配置请谨慎使用
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO
exec sys.sp_configure 'max server memory (MB)',1024
RECONFIGURE WITH OVERRIDE
Go
select value,* from sys.configurations where name like '%max server memory (MB)%'
一般需给系统预留一部分内存，修改后立即生效。
配置值：代表相关设置值 运行值:查看配置是否成功。
-- 获取SQL Server允许同时用户连接的最大数
select @@max_connections as max_connections;
-- 获取自上次启动 SQL Server服务 以来连接或试图连接的次数
SELECT @@CONNECTIONS as CONNECTIONS;
The Tencent Open Source Mirror Site has been launched recently. Its official name is Tencent Cloud Software Source, which is supported by Tencent Cloud.
The official said that the purpose of building this open source mirror station is to promote the value of free software, improve the cultural atmosphere of the free software community, and promote the application of free software in China.
Tencent's open source software image site provides downloads of major Linux distributions such as Ubuntu, Arch Linux, CentOS, and Debian, as well as popular open source projects and SDK downloads such as the Android SDK, Ceph, Flutter, Qt, and Zabbix.
In terms of speed, some netizens provided a screenshot of the Ubuntu ISO file for reference:
By using the Tencent cloud image source, the problem of slow access to the official source when installing software dependencies can be solved to some extent.
In addition, Tencent software source station supports public network access and intranet access of Tencent cloud server. Cloud servers without public network export can use software source station through intranet, which is convenient for users to freely build service structure.
微信国内7.0.5版发布，Play版需再等等...
