1.查询所有
SELECT * FROM sysprocesses WHERE dbid in(
select database_id from sys.databases where name='ECS_DEV'
)order by program_name;
2.查询连接数
SELECT program_name,COUNT(1) FROM sysprocesses WHERE dbid in(
select database_id from sys.databases where name='ECS_DEV'
)group by program_name;
3.查询服务器运行程序连接数
SELECT count(*) FROM sysprocesses WHERE dbid in(
select database_id from sys.databases where name='ECS_DEV'
)and hostname='EDSS-SVR' and program_name='Microsoft JDBC Driver for SQL Server';
select * from
4. 查询当前连接数
select count(distinct(login_time)) from sys.sysprocesses
5. 设置最大连接数
exec sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE
GO文章来源地址https://www.toymoban.com/news/detail-455865.html
exec sp_configure 'user connections', 300
GO文章来源：https://www.toymoban.com/news/detail-455865.html
RECONFIGURE WITH OVERRIDE
GO
到了这里，关于在sql server数据库设置最大并发连接数的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！
