View how many SQL connections are active in an IIS application pool?
Posted on 2014-03-13
I can use Perfmon.exe to view the number of active SQL connections, but i don't know how to further narrow that down to see how many active connections exist in a particular IIS application pool. Is there anyway for me to see, via a SQL command, or an IIS command or a Perfmon counter....how many active SQL connections are being utilized in a given IIS application pool? Thanks!
MSSQL 2012, Windows 2012 R2 Server, IIS8