What's the TARGET_RECOVERY_TIME and recovery interval that has been configured on your databases ? Both values are set to '0'

added: How many VLFs are to be handled...

Create a DML audit on that and double check the data cant be inserted from outside. Next time when the issue pops up , check the DML audit log to...

Hi,

Need your help. I've a SP that is using Update statement on a table.

2-3 processes are updating this table at the same time. I'm getting frequent blockage. How can...

Hi,

Need your help. I've a SP that is using Update statement on a table.

2-3 processes are updating this table at the same time. I'm getting frequent blockage. How can...

Are there indications for the slow operation in the sql server errorlog files?:I couldnt find anything specific in sql error log during the recovery phases

Is the always on node...

Thank you Johan for the response. Please find my inline comment

Is this a clustered sql server instance ?Yes, its a 3 node windows cluster in which 2 nodes are...

You mean Geo-Replicas for your Azure SQL Managed instance? If its...

Really appreciate your effort and thanks for sharing the wonderful script.

Will be more beneficial if you can include hostname & loginname.

Happy New year

duplicate posts

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

SQL Server is not going to be able to validate duplicate documents. It just doesn't work like that. Maybe with SQL Server 2025 and the new AI functionality, but...

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

duplicate

• This reply was modified 1 year ago by VastSQL.

duplicate

• This reply was modified 1 year 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...