sqlserver获取当前时间_查看sqlserver连接数

1、获取SQL Server允许同时用户连接的最大数

SELECT @@MAX_CONNECTIONS

2、获取当前指定数据库的连接信息

SELECT * FROM master.dbo.sysprocesses WHERE dbid IN

(

SELECT dbid FROM master.dbo.sysdatabases

WHERE NAME='YourDataBaseName'

)

--根据需要更改YourDataBaseName

SELECT * FROM master.dbo.sysprocesses WHERE DB_NAME(dbid) = 'YourDataBaseName'

3、获取当前SQL服务器所有的连接详细信息

SELECT * FROM sysprocesses

以上查询结果包含了：系统进程和用户进程。

如果只是想查用户进程的话则需采用下面的方法

4、获取自上次启动 SQL Server服务 以来连接或试图连接的次数

SELECT @@CONNECTIONS

5、查看当前数据库系统所有请求情况

SELECT ds.session_id,

ds.status,

Db_name(dr.database_id) AS database_name,

ds.login_name,

ds.login_time,

ds.host_name,

dc.client_net_address,

dc.client_tcp_port,

ds.program_name,

dr.cpu_time,

dr.reads,

dr.writes,

dc.num_reads,

dc.num_writes,

ds.client_interface_name,

ds.last_request_start_time,

ds.last_request_end_time,

dc.connect_time,

dc.net_transport,

dc.net_packet_size,

dr.start_time,

dr.status,

dr.command,

dr.blocking_session_id,

dr.wait_type,

dr.wait_time,

dr.last_wait_type,

dr.wait_resource,

dr.open_transaction_count,

dr.percent_complete,

dr.granted_query_memory

FROM Sys.dm_exec_requests dr WITH(nolock)

RIGHT OUTER JOIN Sys.dm_exec_sessions ds WITH(nolock)

ON dr.session_id = ds.session_id

RIGHT OUTER JOIN Sys.dm_exec_connections dc WITH(nolock)

ON ds.session_id = dc.session_id

WHERE ds.session_id > 50

ORDER BY ds.program_name

6、用户连接数

SELECT login_name,

Count(0) user_count

FROM Sys.dm_exec_requests dr WITH(nolock)

RIGHT OUTER JOIN Sys.dm_exec_sessions ds WITH(nolock)

ON dr.session_id = ds.session_id

RIGHT OUTER JOIN Sys.dm_exec_connections dc WITH(nolock)

ON ds.session_id = dc.session_id

WHERE ds.session_id > 50

GROUP BY login_name

ORDER BY user_count DESC