Share via

Tools to detect the read write load on SQL Server

SVA 121 Reputation points
2022-07-03T04:49:09.083+00:00

Is there any good tool to find out the SQL Server read write load and identify the resource contention and improve performance

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

Answer accepted by question author

Seeya Xi-MSFT 16,756 Reputation points
2022-07-04T06:12:27.01+00:00

Hi @ShanlyV-5349,

Welcome to Microsoft Q&A!
Performance Monitor is also known as Perfmon and this tool helps to track metrics about computer resources or installed applications.
For more information, please refer to this article: https://www.sqlshack.com/sql-server-troubleshooting-disk-i-o-problems/
In the additional part of the article, I see that there is another tool. It is not a Microsoft product, but you can try it.

Best regards,
Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.