如何获取SQLServer数据库的连接数

最新推荐文章于 2019-01-26 14:34:31 发布

lizhao320

最新推荐文章于 2019-01-26 14:34:31 发布

阅读量167

点赞数

文章标签：数据库

1：V_SYS_CONTRACTIONS （获取系统连接数）

SELECTCOUNT(*) AS CONNECTIONS FROM master.sys.sysprocesses

2：V_SYS_DB_CONTRACTIONS(获取某数据的连接数)

SELECThostname, program_name, hostprocess, cmd, spid, kpid, blocked, waittype,waittime, lastwaittype, waitresource, dbid, uid, cpu, physical_io, memusage,login_time,

last_batch, ecid,open_tran, status, sid, nt_domain, nt_username, net_address, net_library,loginame, context_info, sql_handle, stmt_start, stmt_end, request_id

FROMmaster.sys.sysprocesses

WHERE(dbid =

(SELECT dbid

FROM master.sys.sysdatabases

WHERE (name = 'XXDBName')))

3：V_SYS_NET_CONRACTIONS（获取网路地址连接数）

SELECTCOUNT(DISTINCT net_address) - 1 AS connectnum FROM master.sys.sysprocesses

4：V_SYS_USER_CONTRACTIONS（获取用户连接数）

SELECTcntr_value AS User_Connections

FROMmaster.sys.sysperfinfo AS p

WHERE(object_name = 'SQLServer:General Statistics')

AND (counter_name = 'User Connections')