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 5 years, 4 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 5 years, 4 months ago by Johan Bijnens.

also to be kept in mind: heaps.

You should rebuild heaps too, to activate the checksum mechanism.

Alter table [yourschema].[yourtable] rebuild

for a start, maybe use sentryone plan explorer (free) to replay the exported deadlock xml

ever considered sequences ?

Also double check your backup share, I've had a case where the storage admins enabled compression for the volume holding the SQLServer backups, and it created an ugly mess for...

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

I think the podcast should fit 1 hour 😉

I...

Also keep in mind, you can just update the statistics.

Have a look at Erin Stellato's advices: https://sqlperformance.com/2017/10/sql-statistics/updates-to-statistics

or even the one on how you can use Ola's solution to perform...

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

And of course keep in mind you also have the transaction option "Snapshot"