Keep in mind a unique constraint is materialized as a unique index.

You'll need to contact your devs and get their accord.

Don't just disable/drop without consent

Nice one 🙂

I would restart the full server ( OS )

I've seen this happening on some of our SQL2008R2 instances on very rare occasions

create-an-html-report-on-the-status-of-sql-server-agent-jobs

On top of Steve's reply:

Make an inventory of all "non-default" collations in your instance / db  and find the reason for that/those.

In many cases it is unintentional or someone scripted...

Did you try to show the restore internals in the sql server errorlog file ?

DBCC TRACEON(3004, 3605, -1);

-- trace flag 3014 provides even more backup/restore information

When the applications don't experience errors and end-user experience is satisfied about performance, I would leave it to the engine's db level ( 150 in your case ).

Before altering to...

Did you enable Instant File Initialisation for the service account ? ( on all nodes ? )

Schedule (task scheduler with express edition or sqlagent ) a powershell script that fetches all databases file sizes and reports ( send an email ) when your tresholds are met.

indeed, you'll need to address and monitor tempdb to cope with the rcsi.

Altough, I must admit, we didn't have much problems after enabling it and are using it since it...

Depending on the load of your instance/db, you could try to save the day creating a daily snapshot database and keeping that for a couple of days.

This may not cover...

of course, you can also have a server level login trigger that bounces Windows Authenticated connections

What's the startup size of your tempdb ?

How many files compose tempdb?

Are they equally sized ?

I would indeed never have it fill up a disk/volume, so you can still enable...

Define your sort order to determine "first"

only key columns of an index are used to filter directly on index access

Filters using included columns are only applied after key columns have been processed ( stage 3 )

Included...