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

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

Are you sure your data system really needs it all in actual columns? ( advocate of the devil, I know )

Have you considered putting those "free wheeling columns" into an...

It is indeed a concept that uses tempdb to get it things done. ( versionstore )

The difference between both:

- 'snapshot isolation level" is a transaction setting  ( which has to...

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