I have a production SQL2019 Enterprise SQL Server which hosts an Availability Group with 12 small to medium databases in it.

This is an OLTP server and there is no...

Anyone have faced this issue before?

You can restore Azure SQL DB to same instance with a different name. If you...

Hi

So actual issue is  log restoration is taking time . Need to debug it.Can anybody provide pointers why ist taking time to restore log backup files

Its dedicated dr server...

Hi

We have logshipping which get out of synch in night due to purging process of production but iy eventually gets synhced by morning .But now its taking time to...

.

• This reply was modified 1 year, 4 months ago by VastSQL.

I have a 3 terabyte database that is taking over 5 hours to backup and restore. I'm utilizing multiple files to do the backup. We are on an Azure...

From ChatGPT:

Based on the provided XML deadlock graph, there are two victim processes (process4d93468 and process4cfdc28) involved in the deadlock. The deadlock occurred between two DELETE operations on the...

Start with avoinding functions in where clauses ! ( needs full ( index ) conversion before actual use )

Declare @RefTs datetime2(0) = dateadd(MM, datediff(MM, 0, GETDATE())...

Synonyms.  Views.  Joins that...

Can you save and post the deadlock graph ? An .xdl file can directly be opened by e.g. Solarwinds Plan Explorer (free tool), which has a great replay...

Sorry missed the attachment. Uploaded the...

Thanks all the experts.Sorry I missed the attachment. Please have a look at the attached.

Seems like the issue is due to parallelism, Any experts here can give more insight.

Thanks...