Performance monitoring and tuning is a crucial part of your database administration skill set so as to keep the performance and stability of your server great, and to be able to find and fix the possible issues. The overall system performance can decrease over time; your system may work with more data or even become totally unresponsive. In such cases, you need the skills and tools to find the issue to bring the server back to normal as fast as possible. We can use several tools on the operating system layer and, then, inside the SQL Server to verify the performance and the possible root cause of the issue.
The first tool that we can use is the performance monitor, which is available on your Windows Server:
Performance monitor can be used to track important SQL Server counters, which can be very helpful in evaluating the SQL Server Performance...