如何查看活动的 SQL Server 连接? [英] How do I see active SQL Server connections?

问题描述

我使用的是 SQL Server 2008 Enterprise.我想查看任何活动的 SQL Server 连接，以及所有连接的相关信息，例如来自哪个 IP 地址、连接到哪个数据库等等.

I am using SQL Server 2008 Enterprise. I want to see any active SQL Server connections, and the related information of all the connections, like from which IP address, connect to which database or something.

是否有解决此问题的现有命令?

Are there existing commands to solve this issue?

推荐答案

您可以使用 sp_who 存储过程.

You can use the sp_who stored procedure.

提供有关 Microsoft SQL Server 数据库引擎实例中当前用户、会话和进程的信息.可以过滤信息以仅返回那些不空闲、属于特定用户或属于特定会话的进程.

Provides information about current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine. The information can be filtered to return only those processes that are not idle, that belong to a specific user, or that belong to a specific session.

这篇关于如何查看活动的 SQL Server 连接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！