to add:

Shrinkfile: DBCC SHRINKFILE this also explains what's special for log files !

intro VLF: "A Busy/Accidental DBA’s Guide to Managing VLFs"

read: "Important change to VLF creation algorithm in...

Also keep in mind you cannot truncate a table that is parent table for other tables. (FK relationships)

It's a lazy workaround, right.

It'll have to do for now.

Thank you for the feedback.

Have you tried to checkpoint all databases to see if these connections vanish ?

[style size="30"]text to be formatted size 30[/style]

results to:  not what I thought it would

• This reply was modified 3 years, 5 months ago by Johan Bijnens.

This is something where the question itself is kind of nonsensical, like what is better eating a steak or watching a good TV show.  There might be some overlap...

My bad ( I must have overlooked it because it shows as regular text in stead of a link )

fyi: Negative Blocking Session Ids

pick the one your consumer complaints most about.

After all, "slow" is a consumer experience.

does the query return a row with the given test data ?

How will your app react if there is no row returned?

thank you for the feedback.

ah, another issue with Windows 2022 !!

( we have an issue with HyperV clustered on Win2022 ( bluescreens ) )

Are the needed certificates installed on your SQL2019 ?

Easiest with DBATools Copy-DbaCredential

I hope your backups are in place !

If so, try to make an extra log-backup.

Secondly check your disk subsystem !

Only if that is ok, you are to restore the affected...

Check these articles:

Windows Server Failover Clustering with SQL Server

What is a SQL Server failover clustering

And with regards to Backups: Nothing changes compared to stand-alone instances