Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

High to troubleshoot high cpu and high memory usage happening on the same time? Expand / Collapse
Author
Message
Posted Wednesday, July 23, 2014 1:32 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 12:06 PM
Points: 24, Visits: 78
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.
Post #1595690
Posted Thursday, July 24, 2014 8:20 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 15, 2014 12:48 PM
Points: 35, Visits: 330
Using Hyper-V Dynamic Memory?
Post #1595904
Posted Monday, July 28, 2014 3:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 4, 2014 1:04 AM
Points: 20, Visits: 51
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/
Post #1596742
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse