Post reply

High to troubleshoot high cpu and high memory usage happening on the same time?

  • July 23, 2014 at 1:33 pm

    #310297

    Hi Experts.

    What would be the proper troubleshooting approach for the below performance issue.

    Server is 100% cpu and 90% memory usage and users are unable to login.

    What all things need to be checked? IF users cannot login to the server, how can we troubleshoot?

    Seeking for help and inputs on this.

    Thanks in advance.

  • July 24, 2014 at 8:20 am

    #1732104

    Using Hyper-V Dynamic Memory?

  • July 28, 2014 at 3:50 am

    #1732739

    Restart SQL service (if downtime is permissible) and connect via DAC.

    use select * from sys.dm_exec_requests to see what requests that is executed against the databases. You will see wait types, wait resources, etc. It will give you more info then sp_who2. High CPU usage can be caused by a lot of reasons like:

    Bad execution plans caused by bad statistics

    Locks and blocks

    DBCC CHECKDB

    Index rebuild

    etc

    The below link provides more details on scripts for troubleshooting:

    http://sqlserver-help.com/2014/07/17/script-find-currently-executing-queries-blocking-waits-statement-procedure-cpu/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply