SCOMSQL01 OpsMgr SQL Server

Hourly Stats for: 04/21/2019 19:00

System Information

  • System: VMware, Inc. - VMware Virtual Platform
  • Hardware: 2 CPUs - 8 Total Cores - 16GB System Memory
  • OS: Microsoft Windows Server 2008 R2 Datacenter 64-bit
  • Last Booted: 12/18/2015 18:12:38
  • Uptime: 817.81 Hours (34 Days 1 Hours)

System Resource Pie Graphs

AvailableBytes:	2137.83 MB
WorkingSet:	13788.93 MB
PoolNonPaged:	80.7 MB
Cache:		280.35 MB AvailableBytes:	2137.83 MB
WorkingSet:	13788.93 MB
PoolNonPaged:	80.7 MB
Cache:		280.35 MB AvailableBytes:	2137.83 MB
WorkingSet:	13788.93 MB
PoolNonPaged:	80.7 MB
Cache:		280.35 MB AvailableBytes:	2137.83 MB
WorkingSet:	13788.93 MB
PoolNonPaged:	80.7 MB
Cache:		280.35 MB AvailableBytes:	2137.83 MB
WorkingSet:	13788.93 MB
PoolNonPaged:	80.7 MB
Cache:		280.35 MB PageFile Used:	14618.03 MB
PageFile Free:	18147.14 MB
Percent Free:	55.39% PageFile Used:	14618.03 MB
PageFile Free:	18147.14 MB
Percent Free:	55.39% SCOMSQL01 Drive C:
Used Space:	51.86 GB
Free Space:	48.04 GB
Total Space:	99.9 GB
Percent Free:	48.08%" SCOMSQL01 Drive C:
Used Space:	51.86 GB
Free Space:	48.04 GB
Total Space:	99.9 GB
Percent Free:	48.08%" SCOMSQL01 Drive D:
Used Space:	0.8 GB
Free Space:	99.2 GB
Total Space:	100 GB
Percent Free:	99.21%" SCOMSQL01 Drive D:
Used Space:	0.8 GB
Free Space:	99.2 GB
Total Space:	100 GB
Percent Free:	99.21%" SCOMSQL01 Drive F:
Used Space:	143.2 GB
Free Space:	56.8 GB
Total Space:	200 GB
Percent Free:	28.4%" SCOMSQL01 Drive F:
Used Space:	143.2 GB
Free Space:	56.8 GB
Total Space:	200 GB
Percent Free:	28.4%" SCOMSQL01 Drive L:
Used Space:	24.28 GB
Free Space:	75.72 GB
Total Space:	100 GB
Percent Free:	75.72%" SCOMSQL01 Drive L:
Used Space:	24.28 GB
Free Space:	75.72 GB
Total Space:	100 GB
Percent Free:	75.72%" SCOMSQL01 Drive T:
Used Space:	11.28 GB
Free Space:	88.59 GB
Total Space:	99.87 GB
Percent Free:	88.7%" SCOMSQL01 Drive T:
Used Space:	11.28 GB
Free Space:	88.59 GB
Total Space:	99.87 GB
Percent Free:	88.7%" SCOMSQL01 Drive U:
Used Space:	35.76 GB
Free Space:	64.11 GB
Total Space:	99.87 GB
Percent Free:	64.2%" SCOMSQL01 Drive U:
Used Space:	35.76 GB
Free Space:	64.11 GB
Total Space:	99.87 GB
Percent Free:	64.2%"

Top 5 CPU Processes at 1/21/2016 8:01:21 PM - Max CPU Percent per Process is 800% (8 cores x 100%)

%CPUPIDNameCommand
1171268sqlservr"C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER
9.44684ifindifind.exe -j 442614 -a 2:3295 -t 2 -d KWTEBRPALCVM11.fsgsaas.com*KWTEBRPALCVM11*8400*8402 -r 1453341647 -ab 0 -i 0 -cs kwtebrpawcvc01 -jt 442614:4:1 -systemFiles -mountPath -seb -ffe 0 -lf 267534 -li 439772 -ls 425366 -cn khonemdcsql05 -vm Instance001
7.8836msmpeng"C:\Program Files\Microsoft Security Client\MsMpEng.exe"
3.11512avagent"C:\Program Files\avs\bin\avagent.exe" /ServiceStart "--logfile=C:\Program Files\avs\var\avagent.log"
1.6572lsassC:\Windows\system32\lsass.exe
CounterMin ValueMax ValueAvg Value
Total CPU Usage042.6715.35
CounterMin ValueMax ValueAvg Value
Processor 0080.0618.71
Processor 1073.6713.07
Processor 208315.43
Processor 3073.214.89
Processor 4087.3814.49
Processor 5069.7515.63
Processor 6079.2418.71
Processor 7065.9711.88
ALL087.3815.35
CounterMin ValueMax ValueAvg Value
Avail Memory1989.962298.692236.54
Used Memory13474.0213717.313524.35
Cache Bytes (MB)278.66476.7300.82
Pool Nonpaged Bytes (MB)80.6580.7380.67
CounterMin ValueMax ValueAvg Value
% CPU Privileged Time08.850.86
% CPU User Time041.214.49
Processor Queue Length030.1
% Page File Usage1.51.571.54
CounterMin ValueMax ValueAvg Value
Pages/sec0484.975.65
Page Reads/sec060.720.5
Page Writes/sec00.50
CounterMin ValueMax ValueAvg Value
Total Disk Avg Write (ms)03.240.71
Total Disk Avg Read (ms)011.440.8
Total Disk Split IO/sec05.60.44
CounterMin ValueMax ValueAvg Value
Disk 0 c: Avg Write (ms)04.490.75
Disk 0 c: Avg Read (ms)014.10.62
Disk 0 c: Disk Split IO/sec05.60.42
Disk 1 d: Avg Write (ms)000
Disk 1 d: Avg Read (ms)01.30.01
Disk 1 d: Disk Split IO/sec000
Disk 2 f: Avg Write (ms)03.110.14
Disk 2 f: Avg Read (ms)012.650.73
Disk 2 f: Disk Split IO/sec000
Disk 3 l: Avg Write (ms)03.040.63
Disk 3 l: Avg Read (ms)010.01
Disk 3 l: Disk Split IO/sec000
Disk 4 t: Avg Write (ms)06.410.87
Disk 4 t: Avg Read (ms)013.20.52
Disk 4 t: Disk Split IO/sec00.40.01
Disk 5 u: Avg Write (ms)000
Disk 5 u: Avg Read (ms)06.80.03
Disk 5 u: Disk Split IO/sec000
CounterMin ValueMax ValueAvg Value
Disk Current DQL0190.25
Disk Avg DQL03.070.18
CounterMin ValueMax ValueAvg Value
Disk 0 c: Current DQL020.02
Disk 0 c: Avg DQL00.090.01
Disk 1 d: Current DQL000
Disk 1 d: Avg DQL000
Disk 2 f: Current DQL0190.16
Disk 2 f: Avg DQL03.050.12
Disk 3 l: Current DQL010.01
Disk 3 l: Avg DQL00.240.03
Disk 4 t: Current DQL080.05
Disk 4 t: Avg DQL00.230.02
Disk 5 u: Current DQL000
Disk 5 u: Avg DQL000
CounterMin ValueMax ValueAvg Value
Disk Read Mb/s015.30.41
Disk Write Mb/s034.023.51
CounterMin ValueMax ValueAvg Value
Disk 0 c: Read Mb/s01.890.02
Disk 0 c: Write Mb/s01.280.08
Disk 1 d: Read Mb/s000
Disk 1 d: Write Mb/s000
Disk 2 f: Read Mb/s00.880.04
Disk 2 f: Write Mb/s030.172.16
Disk 3 l: Read Mb/s000
Disk 3 l: Write Mb/s01.250.22
Disk 4 t: Read Mb/s015.250.35
Disk 4 t: Write Mb/s013.041.06
Disk 5 u: Read Mb/s000
Disk 5 u: Write Mb/s000
CounterMin ValueMax ValueAvg Value
NIC 0 Received Mb/sec01.380.3
NIC 0 Sent Mb/sec08.460.47
Total Received Mb/sec01.380.3
Total Sent Mb/sec08.460.47
CounterMin ValueMax ValueAvg Value
SQL User Connections141166153.12
SQL Compilations/Sec0117.1935.95
SQL Re-Compilations/Sec073.4413.73
SQL Batch Requests/sec0929.5201.25
SQL Log Flushes/sec0630.4165.64
SQL Lazy Writes/sec05.70.25
SQL Page Splits/sec0241.467.13
CounterMin ValueMax ValueAvg Value
SQL Buffer Cache Hit Ratio99.94100100
SQL Cache Memory (MB)32.1932.1932.19
SQL Total Memory (GB)10.7410.7410.74
SQL Target Memory (GB)10.7410.7410.74
CounterMin ValueMax ValueAvg Value
SQL Processes Blocked020.03
SQL DeadLocks/sec00.10
SQL Locks Avg Wait(ms)0319868.03
SQL Latches Avg Wait(ms)04.870.85