They are still image and text data types (legacy industrial tech "we will not change it for you" salesperson ). Out of row by default if I'm correct., but indeed,...

That's indeed what I've been thinking, but I have not that much experience when it comes to storing LOBs ( up to 1GB ) in the database, so I've been...

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

Isn't CMS hosted in msdb?

You cannot put systems databases in an AOAG.