Thank you. It makes a lot of sense. its a 7TB db and I asked them to reach out to DB Team.

Here, the dev team size is 48 members and...

just trying to understand if these turn out to be real database issue or app server issue which might throw a generic issue.

how to narrow down such issues?

I am grateful for your valuable suggestions. Thank you very much sir.

Doing index maintenance wrong is much worse than doing none at all... and you ARE doing it wrong.  Yes, you're probably following some form of "Best Practices"... I'm here to...

On  high level, assuming its a new project? what questions you will be asking to the business ? and lets say. I have collected the database size per file for...

[/quote]

Post the CREATE TABLE statement for the table the index is a part of including the CREATE statements for the index(es) in quesiton.  Then, post the results of a run...

The only sure way to do forecasting is to measure today, measure next week (or have measured last week), and do some calculations. Redgate Monitor (yes, full disclosure, my...

We have maxed out 32 Azure VM limit. if we have to resize the vm, we need to go from 32...

Hey there, Sam...

The spreadsheet you included says that a restart occurred only 4 days earlier... that's not good enough to tell if an index is read from or not. ...

Another 3 followup questions

1 . When do we see index size is greater than actual data size of the table?  is that because of creation of too many non-clustered duplicate...

Thank you Grant sir. All I can sense is, this has to be carefully dealt with a proper index performance tuner or consultant.

Just want to ask, is there any easy...

I understand my ask is to vague at this point. I totally get it.

All my ask is, at very high level . I we have to build a new server...

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.