Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
New SQL server, slow load time
#1
We're migrating to a new SQL server and I moved our ASG database to it tonight by detaching, copying to new server, and attaching it. I updated my connection manager to the new server. Now time to load the application takes about 2 minutes to load when it previously took seconds.

Any ideas on why this could be so much slower than the old SQL server/database?
Reply
#2
Not really - bad connection to sql server (network) - or extensive logging on new sql server? Normally But from seconds to minutes it sounds really strange - same data should not take so much longer than before...
Regards/Gruss
Oliver
Reply
#3
(23-11-2020, 08:24 AM)DevOma Wrote: Not really - bad connection to sql server (network) - or extensive logging on new sql server? Normally But from seconds to minutes it sounds really strange - same data should not take so much longer than before...

Agreed. Noticing some slowdowns on some other apps so guess I need to dig into the root cause, the server itself may be misconfigured somehow.
Reply




Users browsing this thread: 1 Guest(s)