Start with Database Migration Assistant (DMA)

but I don't think it holds migration data for ssis.

• This reply was modified 4 years, 8 months ago by Johan Bijnens.

MADE MY DAY ! ! 😀

Thank you for sharing this estonishing "story from the trenches".

Happy new year.

I think you forgot to pose the question related to this execution plan.

Just reply the question and attach the .sqlplan renamed to .txt file.

Happy new year !

Why did you configure that many Listeners ?

A listener is a AD object, managed by your windows cluster.

A single one could be sufficient to have you AG available

listeners-client-connectivity-application-failover

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/create-or-configure-an-availability-group-listener-sql-server

Check out Query Store

my QS ref: https://www.sqlskills.com/blogs/erin/category/query-store/

I hope you mean the TSQL way for compression!

 backup database xyz ... with compression ;

Do not use compression at windows operating system level !

Unless you have...

• This reply was modified 4 years, 9 months ago by Johan Bijnens.

Double check your target folder itself ( or volume ) has not been enabled for compression !

SQLServer does weird things when someone enables compression at disk level.

are you producing striped backup files ?  (  Backup database - working with a striped media set )

That may also help to reduce the time needed. ( if that...

This is how I collect the mirroring events:

/*

DBA_DBMirroring_Events: follow up state changes of mirrored databases

-- This implementation uses SQLServer Service Brocker with Event Notifications

*/
set QUOTED_IDENTIFIER on;
go

USE YourDBAMonitoringDB;

if...

how do you monitor your mirrored databases?

Do you log the mirroring failover messages ?

Check the failed login at sqlserver side. What are the details SQLServer states ( errorlog / xevents...

Thanks, I'm going to try removing the nonclustered indices. But my problem, I think it is that it is not possible to shrink the mdf file below its initial...

shoud hold a quote, it didn't 🙁

• This reply was modified 4 years, 9 months ago by Johan Bijnens.