NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: TimR on July 22, 2025, 01:35:37 PM

Title: Webserver performance slow after restart
Post by: TimR on July 22, 2025, 01:35:37 PM
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
Title: Re: Webserver performance slow after restart
Post by: Bruce on July 22, 2025, 03:22:58 PM
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?

Title: Re: Webserver performance slow after restart
Post by: TimR on July 23, 2025, 11:22:19 AM
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.
Title: Re: Webserver performance slow after restart
Post by: osquiabro on July 24, 2025, 03:31:34 AM
what version of NT? i have a large database about 1tb in SQL and NT without any problem.
But I never use tps
Title: Re: Webserver performance slow after restart
Post by: TimR on July 24, 2025, 07:58:48 AM
14.26, the issue has been ongoing over several versions, this is a multi host server, many databases used
Title: Re: Webserver performance slow after restart
Post by: osquiabro on July 25, 2025, 03:41:55 AM
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.