Hello,
Below are the configuration of the server
Processor : Intel(R) Xeon(R) CPU E7-4870 v2 @ 2.30GHz, 2294 Mhz, 1 Core(s), 1 Logical Processor(s)
System Model : VMware Virtual Platform
OS Name : Microsoft Windows Server 2012 Standard
Installed Physical Memory (RAM): 24.0 GB
SQL Server : Microsoft SQL Server Standard (64-bit)
Installed Location : D:\Program Files\Microsoft SQL Server\
Processor : 8
Memory : 24575 (MB)
Minimum Server memory in MB : 8192
Maximum server memory in MBB : 12044
SCCM version 2010 uses the SQL Database. CPU and Memory usage becomes high and alert generated.
CPU Load: 100 %
%Memory Used: 77 %
This is started at 6:57AM and became normal at 9:19AM. This happens at random time interval.
Please help me to troubleshoot and fix the issue