I use at my work an web application for human resources. It runs on a cluster with 2 web servers IIS and 1 Microsoft SQL Server 2017 as DB. The last weeks the system is slow and w3wp process goes using all the memory.When it gets to 100% i have to restart the server.
They ask me to run a performance monitor on these servers with different counters:
3.Memory(RAM) for every session.
4.Number of Database Requests for every session and the Total of them.
I really dont know what counters to run in the performance monitor,and I really want to know what is consuming all that Ram.
Thank you in advance.