locked
SQL server Performance RRS feed

  • Question

  • Hi,

    There are lot of monitoring tools in MSSQL server

    can i know the difference between them. What are the changes that are applied in each monitor tools.

    Wednesday, February 26, 2020 6:19 AM

All replies

  • 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

    Wednesday, February 26, 2020 12:47 PM
  • Hi iammani,

    Is the reply helpful for you?

    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. 

    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

    Saturday, February 29, 2020 5:05 AM
  • hi

    Activity Monitor
    Start SQL Server Management Studio.
    To open Activity Monitor: Right-click the SQL Server instance node and select Activity Monitor,
    or. Press Ctrl+Alt+A, 
    or. Click the Activity Monitor icon in the menu.


    MS SQL Server Log Auditing Tool link

    https://www.manageengine.com/products/eventlog/sql-auditing-tool.html#ddl

    query link
    https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15


    The beloow monitoring


    Memory and CPU utilization
    Locks
    Indexes
    Buffer and cache
    SQL queries
    Replication details
    Jobs and sessions details

    https://www.manageengine.com/products/applications_manager/sql-server-monitoring.html?network=g&device=c&keyword=sql%20server%20monitoring%20tools&campaignid=1689686871&creative=407439896555&matchtype=e&adposition=&placement=&adgroup=65153215159&targetid=kwd-302758204309&location=9040231&gclid=EAIaIQobChMIopvLyqz25wIV1AorCh0bHwgeEAAYAyAAEgJQtfD_BwE

    Saturday, February 29, 2020 8:44 AM