Joey on SQL Server. Why Activity Monitor May Be Hurting Your SQL Server's Performance . ... so I use an assortment of open source tools and scripts that provide data about a given SQL Server instance.

Launch your SQL Server Management Studio. Click the standard toolbar and then choose the activity monitor. Locate the session identification number in your activity monitor for the connection you ...