在sqlserver数据库设置最⼤并发连接数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
select distinct fromGO
RECONFIGURE WITH OVERRIDE
GO
exec sp_configure 'user connections', 300
GO
RECONFIGURE WITH OVERRIDE
GO

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。