Webserver performance slow after restart

[TimR]

I'm having an issue with a webserver when it restarts where the performance is painfully slow. To set the scenario, I have a powershell script that runs and monitors that the webserver is running, it checks every minute. If it isn't running, it starts the webserver. After the restart the webserver responds to requests very slowly, until I shutdown the webserver for 10-15 minutes (timeframe is approximate), or restart the server. Database is MSSQL with some topspeed files. Has anyone else experienced this behavior and even better figured out a cause

[Bruce]

In the WebServer procedure, NetTalk extension, Performance tab (I think) there's an option along the lines of "save server state between runs".
In your system is this option on?

[TimR]

Yes, it is checked on. I've tried unchecking it and I'm fairly certain the issue remains(it was a while ago when I was testing). I only get this behavior when the webserver unexpectedly closes (hence the script to keep it running). I haven't been able to figure out why it closes randomly, I suspect it might be getting disconnected from the sql server, but haven't confirmed it. It runs for days-weeks before restarting.

[osquiabro]

what version of NT? i have a large database about 1tb in SQL and NT without any problem.
But I never use tps

[TimR]

14.26, the issue has been ongoing over several versions, this is a multi host server, many databases used

[osquiabro]

try in your conection strings this

DRIVER={SQL Server Native Client 11.0};VERIFYVIASELECT=True;MARS_Connection=Yes;BUSYHANDLING=2

very important that sqlclient version 11 is intalled

my site is multi host https://istpr.com/

GPF Report is a good tool for this problems, i think the problem is a an embedded code a not NT.

I'm on version 14.22 with no major issues. Only on very rare occasions does a gpf report point to xfiles, and I've never been able to resolve it.