also keep in mind , if you are able to extract the deadlock xml (copy/past into a .xdl file), SentryOne PlanExplorer has a nice "replay" feature that shows the sequence...

How about

/* generate DDL */
exec sp_msforeachdb '
Select ''
USE [?]
GO
CREATE DATABASE AUDIT SPECIFICATION [DatabaseAuditSpecification-DatabaseA]
FOR SERVER AUDIT [ServerAuditName]
ADD (INSERT ON DATABASE::[?] BY [dbo]),
ADD (SELECT ON DATABASE::[?] BY [dbo]),
ADD (DELETE...

What's the condition on which you determine which hour to be returned ?

I just encountered this picture which also applies to our line of duty ...

Some monitoring softwares will show blocking in the engine and may get you on track detangling such issues.

If you think (b)locking is the issue, you may even want to try...

Keep your data catalog correct and disable an index if you want to re-enable it later!

This way, persons investigating "troubles" will know someone performed this action on purpose ( as...

indeed, Jeff. Time flies when you're having fun ??

I hope there will be an occasion in the near future, when we have adapted to cope with covid-vnext.

It was a great session, Jeff

Good to hear you again 🙂

It will be good to hear you again. It's been a while for me.

I used to try to solve such quest from within TSQL, as some others suggest.

But nowadays, I keep it out of TSQL using Powershell dbatools !

#of course...

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

btw Errorlog holds information about DBCC CLONEDATABASE !

ref: DBCC CLONEDATABASE (Transact-SQL)

https://dbatools.io/cms/

Clear-Host

$TargetPath = 'c:\SQL_CMS_Export'

Export-DbaRegServer -SqlInstance Your_CMS_SQLInstance -Path $TargetPath
 

explorer.exe "$TargetPath"

<# Results

Your_CMS_SQLInstance-reggroup-DatabaseEngineServerGroup-06022021131433.xml

#>

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

Isn't CMS hosted in msdb?

You cannot put systems databases in an AOAG.

We always use

-- switch sqlserver logfiles (errorlogs)
EXEC msdb.dbo.sp_cycle_errorlog 

and

EXEC msdb.dbo.sp_cycle_agent_errorlog;

We do this in a single SQLAgent job, but in 2 steps, configured so they...

What disturbs me more is the fact that "will never share information" gets thrown overboard.

MS baught Whatsapp for its technology.

Instead of rebranding it to MSwhatever, they opt to keep the...

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