谁在连接sqlserver?
程序员文章站
2022-04-02 16:17:44
...
--谁在连接sqlserver? SELECT [dec].client_net_address, [des].[program_name], [des].[host_name], Count([dec].session_id) AS connection_count FROM sys.dm_exec_sessions AS [des] INNER JOIN sys.dm_exec_connections AS [dec] ON [des].session_id = [dec].session_id GROUP BY [dec].client_net_address, [des].[program_name], [des].[host_name] ORDER BY [des].[program_name], [dec].[client_net_address];
上一篇: 条件放Join里面与Where里面的区别
下一篇: 二分排序法