Hi iammani,
>What are the changes that are applied in each monitor tools.
There are many tools in MSSQL server.
1.In any case, you need to collect the SQL Server ERROR LOG. For SQL Server problems other than performance problems,ERROR LOG can provide direct or indirect
information to help you locate the problem. For performance problems,ERROR LOG can often show where the performance bottlenecks of the current system are.The performance bottleneck is
a very important breakthrough for troubleshooting problems with poor overall performance;
2.The Windows event log is mainly used to troubleshoot SQL Server‘s abnormal downtime and why it
cannot start;
3.For the problem of high CPU usage and slow execution of individual statements, if it is not suitable to use SQL trace, you can use DMV,Perf_stats and Perf_Stats_Snapshot
scripts. The output results of these scripts and views include the most consumed I / O resources,CPU resources and the longest
execution statement, blocking information, wait state, and also contains missing indexes in the database.This information
will help you to make some basic optimizations to the entire database.
And there is one form that list the tools and their differences and how to choose the
suitable one for your situation,please reference: performance-monitoring-and-tuning-tools
Hope this could be helpful.
Best Regards.
yuxi
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com
