Using Qualys for patch management , stil the passive & active servers of clusters are done as different jobs.

duplicate

• This reply was modified 2 months, 2 weeks ago by  VastSQL.

duplicate

• This reply was modified 2 months, 2 weeks ago by  VastSQL.

First of all, I'm aware that it's better to perform an out of place upgrade to reduce downtime and lower the risk of any issues that could arise during...

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 7 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...