Hi freaks
I was forced to upgrade ourWindows-Server and SQL-Server to Version “2025”
No problem but now, when I connect (from our application) the first time to the database it takes 8 seconds
sql/print "SELECT top 1 1 FROM aTable", "DEF"Profiling on MS-SQL give me no hint, as the duration of all action are a few microseconds.
Using procmon results in this picture
UnifAce connects and deconnect several time. Every reconnect last 0.5 seconds so in total we are near the eight seconds (measured by counting aloud)
So what’s going on here?
As I said, it's really just the simple SQL/print statement, nothing else.
Oh yes, when I start the IDF, I got this
What happens here for about two seconds?
Thanks for any hint
Ingo
