The story is very small but the moral of the story is very important. The story is about a client, who had continuously performance issues. The client used it (Read More: SQL SERVER – 2008 – Location of Activity Monitor) to check the performance issues. The pattern of the performance issues was very much common all the time. Every time, after a while the computer stopped responding. After doing an in-depth performance analysis, Jacob realized that client once opened activity monitor never closed it. The same monitor itself is a very expensive process. The tool, which helped to debug the performance issues, also helped (negatively) to bring down the server. After closing the it which was open for a long time, the server did not have performance issues.
Moral of the story: Activity Monitor is a great tool, but use it with care and close it when not needed. Let me know what you think about this in the comment area. I will be reading each of the same and reply.
Reference: Pinal Dave (https://blog.sqlauthority.com)
2 Comments. Leave new
Thanks Pinal.
What is the name of the process in the task manager to find out Activity Monitor?
Regards
Shyam
@shyam to find out the activity monitor …just right click on the server and you will find the option activity monitor. just click on that