How to monitor the SQL server connection pool

I checked the information today and learned how to check the database connection status.
Run sp_who or sp_who2 in the query analyzer. These system stored procedures return information from the sysprocess system table, which displays the status and related information of all worker processes. Generally, you will see a server process ID (spid) for each connection ). If you name your connection by using the application name parameter in the connection string, you can easily find a working connection.