J
Jürgen Barth
Hi,
i Need some help in finding the culprit of a massiv Performance drop in our applications (running on a web Server) after installing the June 2019 cumulative updates.
We have two server and a SQL backend cluster, one of the servers does a nighlty job.
The Server get´s data from the SQL Server and start to process These data.
Until the 13 June, the process time was About 45-50 minutes, each night.
After we installed the Windows 2016-06 Updates after the 13 June,
the process runs About 75-90 minutes.
I wasn´t able to find the culprit now.
i did the following steps to find the problem
I had success with one solution at the 8 July
I did a DISM checkhealth, scanhealth and restorehealth
DISM and sfc /scannow found some Problems with component store, mostly with the Defender files.
After Fixing all the DISM and sfc Errors a last reboot was done at 08 June.
The Server was running like before, processing time was down to 45-50 minutes as usually.
Now after installing the july 2019 updates on 11 July the Performance drop is back again, process time is now at 75-90 minutes.
this time the HP DL120 Gen9 received all Firmware updates and Drivers, as i was confident that the Problem was the corrupted component store. I used the latest HP SSP 19.03.1 (i think this release).
I checked againg and all is fine.
But the process is till slow.
can anyone help in finding the culprit?
the process can only verified after it runs in the night, i can´t start the process manually.
i hope anyone is able help or provide me with some steps.
Kind regards
Jürgen
Continue reading...
i Need some help in finding the culprit of a massiv Performance drop in our applications (running on a web Server) after installing the June 2019 cumulative updates.
We have two server and a SQL backend cluster, one of the servers does a nighlty job.
The Server get´s data from the SQL Server and start to process These data.
Until the 13 June, the process time was About 45-50 minutes, each night.
After we installed the Windows 2016-06 Updates after the 13 June,
the process runs About 75-90 minutes.
I wasn´t able to find the culprit now.
i did the following steps to find the problem
- Removed a SQL 2016 SP2 CU7 Updates on the sql backup
- Checked the NIC Cards on all server and verified that TCP offload, IPv4 offload and larg send offload is disabled.
- chimney is disabled
- Defender is disabled at all (no other AV is running).
- we checked the amount of data, it´s not significant more than before
- all server are HP DL120 Gen9, no Firmware (Bios, Raid, ilo,.. ) where done at the 13 June
- Web Server has SSD Raid1 with 480GB, SQL Server is Cluster solution with iSCSI Storage (all iSCSI has SSD).
I had success with one solution at the 8 July
I did a DISM checkhealth, scanhealth and restorehealth
DISM and sfc /scannow found some Problems with component store, mostly with the Defender files.
After Fixing all the DISM and sfc Errors a last reboot was done at 08 June.
The Server was running like before, processing time was down to 45-50 minutes as usually.
Now after installing the july 2019 updates on 11 July the Performance drop is back again, process time is now at 75-90 minutes.
this time the HP DL120 Gen9 received all Firmware updates and Drivers, as i was confident that the Problem was the corrupted component store. I used the latest HP SSP 19.03.1 (i think this release).
I checked againg and all is fine.
- Defender is disabled at all
- TCP Offload is still disabled on all NIC`s
- I checked Disk performance
But the process is till slow.
can anyone help in finding the culprit?
the process can only verified after it runs in the night, i can´t start the process manually.
i hope anyone is able help or provide me with some steps.
Kind regards
Jürgen
Continue reading...