August 8, 2016 at 6:43 am
We have a number of .Net web applications running under IIS on a web server connecting to our backend SQL 2012 database running on separate Windows server.
I am trying to monitor the number of connections and connection pools used by the web server. I am doing this using the ".NET Data Provider for SqlServer" counter object in Windows Performance Monitor.
My question is : Do I need to run Performance Monitor on the web server in order to monitor connections and connection pools created by web applications hosted on that web server? Or can I run Performance Monitor on the database server and pick up connection data that way, no matter where that connection was initiated from?
August 8, 2016 at 7:28 am
It is not possible for a perfmon collection of a database server's counters to detect a connection issue that exists on a client that is running upon a different server. However, you can collect perfmon data from a remote server. For a programmatic solution, see https://msdn.microsoft.com/en-us/library/system.diagnostics.performancecountercategory(v=vs.110).aspx. For a GUI solution (that unfortunately does not reveal the required open ports and required permissions), see https://blogs.technet.microsoft.com/askperf/2014/07/17/windows-performance-monitor-overview/. And I believe WMI can be used.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply