That's exactily the reason why we scan and alert for such usage (use of own database name).

Do this for as well sprocs, views, functions, ...)

"Sloppy development" like "start from object...

HTH

Please provide feedback on your progress and solution.

The number of VLFs are to be seen per database and will be handled at startup/recovery time ( of the database, as a step in the startup of the instance...

What's the TARGET_RECOVERY_TIME and recovery interval that has been configured on your databases ?

added: How many VLFs are to be handled for your databases ?

• This reply was modified 8 months, 1 week ago by Johan Bijnens.

Are there indications for the slow operation in the sql server errorlog files?

Is the always on node involved with the clustered sqlserver instance ?

if yes, are you using a listener...

Is this a clustered sql server instance ?

Is this a db involved in an Availability group ?

Is query_store active ?  ( did you implement trace flags 7745 / 7752 )

What's...

did you install SQLExpress to host your localdb ?

( Maybe even during your VS2022 install )

ref: "Tutorial: Configure replication between two managed instances"

Exactly THE reason why we avoid linked server usage as much as possible !

SQLserver itself determines "where" the linked server part of the query is being executed.

It may as well...

Do you mean "Azure Managed instance Link" ?

Check the windows folder security at the new location and double check the service account has the needed authority !

double check which account your service is trying to use !

• Use an older operating systemd
• I presume this is a case of DRP or alike, so it should only be used for a short time: make the service account...

please post the actual SQLServer @@version information?

No wonder most of us avoid linked server usage whenever possible

Is this a dedicated sql server machine?

what is you max server memory set to?

Is CDC active on the database in the backup file ?

I started backup right after a server down\up ...

The backup for the past month was working fine... just started this issue a few days ago.

I'm going to try a...