Did you check default trace and/or system_health xe session ?

You can monitor your AG(s) with extended events:

ref: https://tracyboggiano.com/archive/2017/07/monitoring-availability-groups-part-3-extended-events/

Actually, the correct answer is: Who cares !

It is a PaaS solution that takes care of all Backups etc. at the pace / desire of the PaaS provider.

FYI: Brent wrote a nice 101 about Filtered Indexes "What You Can (and Can’t) Do With Filtered Indexes"

FWIW, whenever we disable a job, we leave a trace of it by renaming the job ! (we add a prefix e.g. 'DBA-MaintenanceWindow-'

Doing so, we know who/what did disable the...

Great feedback !

Can you elaborate on the build number of SQL2016 you are using ? Which CU ?

Did you open a case at Microsoft?

Don't you just love storing datetime/date/time information in (var)char columns.?

Now you're stuck with the downsides of this design option.

Don't let the engine guess what format the dates are stored in,...

We mostly use DNS aliasses to have applications connect to our clustered instances.

( more meaningful naming conventions as with our server names )

Doing so, we can migrate the sqlcluster without...

except for the bickering ... did - did not ...

Isn't there also a ratio processor/core(s) vs io chanels vs io threads to keep in mind?

Set aside the tool.

Where and how do you document / manage Databases in a VSTS/DEVOPS/GITalike infrastructure ?

Do you have separate db projects/solution to which devs can pull branches and checkin...

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, 4 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...