Partner and Community Forums
Assistance in troubleshooting TTFB
Last post Jun 09, 2017 08:06 AM by mongobongo
Jun 09, 2017 07:39 AM|mongobongo|LINK
hope someone can assist me in pin pointing the cause of my slow TTFB (Time To First Byte) which occurs only under certain conditions.
Firstly an explanation of the hardware/software involved.
This is a dedicated server hosted at OVH.
The server has only 40 active domains and is a web/email server.
The server has the following specifications
Intel Xeon D 1520
32 GB ECC 2133 MHz
2 x 480GB SSD (Raid1, Physical devices)
Windows Server 2016 1607
Plesk Onyx Ver 17.5.3 Update #8
PHP Server 5.6.35
The issue is happening only with php database driven websites, website that are static php content are OK.
Websites that are using other technologies i.e. .asp, .aspx, html etc are OK.
.aspx - https://www.webpagetest.org/result/170529_F9_BSJ/
.php static - https://www.webpagetest.org/result/170529_2S_BV5/
I have tried many different things to resolve this but each and every time I think its resolved it isn't
One example was to use the hosts file to denote localhost as 127.0.0.1 to avoid any IPv6 related issue with the resolving of 'localhost'
The example below is a Wordpress website that is using the 'the7' theme, 'WP Super Cache' is installed with default settings, PHP version used for the website is 5.6.30.
The website has its own MySQL database and is stored locally on a raid 1 SSD config.
Here is the URL for the result
This issue only seems to occur when the website has not been accessed for an extended period of time.
The extended period of time is unknown as of now but for my testing if the website isnt accessed for lets say 12 hours then the below occurs.
The TTFB on the first run can be in excess of 10 seconds, sometimes even up to 30 seconds, this only happens on the first run and only if the website has not been accessed for the extended period of time indicated above.
So hoping someone can offer some pointers.
Thanks in advance
Jun 09, 2017 08:06 AM|mongobongo|LINK
OK, I lost track on the number of hours I spent troubleshooting this.
But it seems like the fix is the following.
Dont use the balanced power profile!
It never crossed my mind that a Windows Server would default to the 'Balanced' profile.
By simply changing the profile onto the 'High Performance' profile the issue seems to be fixed.
Of course I need to do more testing, but if this is indeed the case why is the 'Balanced' profile acting this was with regards to PHP database driven websites?
Surely this should not be happening.
I feel quite relieved !
** EDIT **
Only twigged thanks to this website