How can I know how many connections are open at a given point of time while I am testing an ASP.Net application? The application uses SQL Server 2000 as its database.
I dont know whether this will do it, but go into query analyzer and type "exec sp_who2". This will show you what connections are open for the entire server, how much resources they are using and when a command was last run. Not completely worked out the information it throws back, but its a start. However I dont know how (if) .Net pools connections so I dont know if this is entirely accurate... anyone?
No comments:
Post a Comment