Why is IIS HTTPS slow to load within SQL Server?
I'm migrating my Windows Server 2008 and SQL Server 2008 instances to Windows Server 2019 and SQL Server 2017. All went well except one issue which took me days to figure out which was HTTPS activation caused slow load within SQL Server.
When I use HTTP, the website load very quickly. When I activate HTTPS it take > 40 seconds to load the same page.
I can't work out why. Is there any setting to activate?
I'm using let's encrypt certificate and it is just a basic installation really nothing extraordinary.
The problem was coming from the IIS where Microsoft integrated HTTP/2 with IIS 10. When it is activated it takes triple time to validate the connection through the SSL. I just deactivated the HTTP/2 and OCSP.
Funniest part is this [Microsoft Docs1 comment:
HTTP/2 is a major upgrade after nearly two decades of HTTP/1.1 use and reduces the impact of latency and connection load on web servers.
- Math.Sin() gives incorrect value
- How to run my python script when the sunOS is start booting
- Express-session: not resetting cookie expiration on each request
- Getting a stack overflow exception when normalizing a vector
- Edit default summary function in R gives error for multiple variables
- What was a For loop? Why isn't it needed in R?
- How to use download button in shiny and save results in various formats (csv, texte, pdf, spss...)?
- Why are there two assignment operators, `<-` and `->` in R?
- lm()$assign: what is it?
- How to get the value of list(...) in R and S functions
- Design matrix for MLM from library(lme4) with fixed and random effects
- how to generate elements not included in my sample
- Create a matrix with gradually changing values without a for loop
- Emacs ESS and S-plus ( S+ ) 8.1 compatability
- How to lag date-index in a time-series in R?
- Nonlinear regression in R / S
- Calling R from S-Plus?