Hi guys,

I just migrated my biggest EDB server project (40 Users) from an Windows Server 2008 to an Windows Server 2019 - and now the app is painfully slow.

The application is the same, the EDB server is the same, the configuration is the same - I just copied it. The new server has more CPU power, more RAM and faster SSDs than the old one.

I deactivated the Antivirus software, set exceptions for the DB folder, no change. Can it be the new SMB protocol that is slowing everything down?

Does someone here have an idea what else I can try? Thanks in advance!

Heiko

SECPOL.MSC

1) Local policy
2) Security options

Change the "Microsoft Network server sign communication always" to "Disabled"
Change the "Microsoft Network server sign communication (if the client agree" to "Disabled"

My windows is in "Portuguese - Brazil" and therefore the settings may be different.

Let me know if it solve (or not) the problem.

Eduardo

Jose,

thank you for your reply. The option was greyed out because overridden by domain policy, but after a while I got it deactivated and forced an update on client and server.

Unfortunately this didn't change anything.

On 3/9/2020 1:42 PM, Heiko Knuettel wrote:
> I just migrated my biggest EDB server project (40 Users) from an Windows Server 2008 to an Windows Server 2019 - and now the app is painfully slow.

Can you determine what is slowing things down  (i.e. are actual queries
taking longer or is it something else that is slow) !?

> The application is the same, the EDB server is the same, the configuration is the same - I just copied it. The new server has more CPU power, more RAM and faster SSDs than the old one.
> I deactivated the Antivirus software, set exceptions for the DB folder, no change. Can it be the new SMB protocol that is slowing everything down?

Sorry - confused over the setup.

Are you using SMB (network share access) or EDB Server (client server
mode) ?


I do realize it's not much help but figuring out the source of the
problem (or simply eliminating factors) would be my first step here.

Raul

Raul,

>>Are you using SMB (network share access) or EDB Server (client server mode) ?<<

Sorry for the confusion. It's an Elevate DB Server, so SMB shouldn't play a role at all. It's just the only difference between the two Windows Servers that came to my mind.

>>Can you determine what is slowing things down  (i.e. are actual queries
taking longer or is it something else that is slow) !?<<

I look into it in more detail tomorrow. One thing where it was extremely obvious today was an edit that fires a query on keystroke to search distinct values from a table with an index. Took a few milliseconds before (you could type without interruption), takes a second now, typing impossible

Overall everything got slower. I'm logging times to open a form (on form open there are several queries and tables opened, memory tables filled with queried data, stuff like that) and these times got twice as high.

On 3/9/2020 6:04 PM, Heiko Knuettel wrote:
> I look into it in more detail tomorrow. One thing where it was extremely obvious today was an edit that fires a query on keystroke to search distinct values from a table with an index. Took a few milliseconds before (you could type without interruption), takes a second now, typing impossible
>
> Overall everything got slower. I'm logging times to open a form (on form open there are several queries and tables opened, memory tables filled with queried data, stuff like that) and these times got twice as high.

That is pretty weird - since you're using EDBServer clearly something is
slower on the host itself. My first suspicion would be AntiVirus and
other network level scanning utilities but i know you said you disabled AV.

Logging session OnRemoteTrace event on client might be worthwhile to see
what happens with requests/responses and timings.

I would try running EDBServer interactively  (instead of service) to see
if this makes any difference to client app  (you'd need to be logged in
on server to do so).

Raul

Heiko


Another thought - what is being autostarted on the machine? msconfig  will give some answers but I'd recommend downloading and using autoruns. I don't know if its still available. Its part of sysinternals which is now part of the Microsoft empire - have a look on https://docs.microsoft.com/en-us/sysinternals/


Roy Lambert

Raul wrote:

>  My first suspicion would be AntiVirus and other network level scanning utilities but i know you said you disabled AV.

Still my second suspicion - and check on the client in particular. I had AV that was being clever and monitoring network connections, but the data was slightly non-standard so it would hold onto things for a while before passing it on, and that caused delays.

I'd also want to be sure there is no network naming or other issue in the way. A 15 second delay can often come from something doing lookups. Indeed, check it isn't still trying to talk to the old server or something.

--

Matthew Jones

>  My first suspicion would be AntiVirus and other network level scanning utilities but i know you said you disabled AV.

Server 2019 comes with Windows Defender installed so is this the antivirus you disabled or was it additional third party running as you already mention it is in a domain environment.

Also to rule out any network issues what is the performance like if you run the application directly on the server if this is possible?