I am a bit late to this conversation, but here goes...

First, what are the business requirements. How much data will change and how often will it change.

If you are...

20TB is definitely a VLDB, and there are a lot of issues beyond just looking at multiple file groups that you need to consider. A DB of that size...

If you do plan to use MSDTC with AGs on Windows 2012 R2, then you need to check out https://support.microsoft.com/en-us/kb/3090973.

Do not assume that anything running on a computer will be bug-free, especially if it has been written by people. This applies to Availability Groups, old-style mirroring, and transactional...

Using multiple files for a database can be useful regardless of the number of physical volumes (spinning rust or SSD) that a single logical volume gets mapped to.

If your IO...

I would want to look at the 2TB drive, to see

a) how much space is used by logs

b) what else is on the drive

Then I would want to look...

Good points Jeff, I completely agree!

Raising problem tickets is the only workable way forward.

Management should work out for themselves they need to escalate and arrange video links or...

I am going to take a wild guess that there is some unwanted interaction between the backup system and SQL Server. It could be that the backup system has...

Have you considered the 'do-nothing' approach. (Well, almost do nothing...)

Evict node 2 from your cluster, then shut it down and decommission it. You are now running on a...

The number of IP addresses you need depends on what you want to do and how your environment is built and what IP protocols you are using. The number...

I remember 370s. I started work in 1974 at a site with two 370/158 boxes, the largest one had a whole 1MB memory. They both ran OS/MVT, supporting...

The URL for the SQL 2014 Books Online is https://technet.microsoft.com/en-us/library/ms130214(v=sql.120).aspx If were all printed out it would be 10cm thick or more. You should find most of your...

One thing that seems to be missing from this discussion are Recovery Time Objective (RTO) and Recovery Point Objective (RPO) (OK, maybe two things...).

The RTO and RPO should...

You will find there are many similarities between SQL Server and Oracle, as well as many differences. It is a long time since I used Oracle, but my memory...

Muhanned, sorry if we have given you a hard time. It looks like you are very much aware of the issues being raised and are trying to make the...