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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy