Below are the autogrowth settings.

for user db

for tempdb

How are you performing your failover?

Mostly it is automatic failover. only when we do a Disaster recovery...

Thank you Scott and Jonathan.

Hi Jonathan, question came into mind, if the batch size is specified as 1000 but assuming if the qualified rows based on where condition is 1050...

Thank you Scott and Jonathan.

Thanks Johan.

Any way to get to know what -2 spid is doing within sql server? I want to know what query is being run through an MSDTC txn?

Try these and see if they help.  Be sure to review the query plan to verify:

INDEX ON mq: ( TABLE_NAME, ROWID_MQ_DATA_CHANGE )

UPDATE mq
SET mq.sent_state_id = 6,
UPDATED_BY...

Current VLF count info and AG properties.

AG properties

700GB log file for a 5TB database?  Have you determined what caused it to grow that large and, if you reduce the size, will it grow to be that...

If Jeffrey, thanks for your inputs. Have some doubts. please clarify.

For a 5TB database - a 700GB transaction log isn't out of the ordinary, and the fact that you only...

One question application team/dev team had is, is there an option available to automatically commit txn's which are opened by the application when using Explicit txn? is there any option...

After doing some research, got this query. For explicit transact, it will show "user_transaction" as txn_name,

if implicit_transaction is ON , then it is showing up as "implicit_transaction" as txn_name.

This reply was modified 1 month ago by  vsamantha35.