Also, as reindexing cycle takes several month, and business is quickly growing and we have more data, there are too many variables.

At least we keep all SLAs with...

• This reply was modified 1 year, 1 month ago by  tzimie.

Snapmanager for SQL allows you to database level backups and avoid the OS freeze. We implemented it as a solution to back up a 3-4 terabyte sharepoint site database...

Yes, we have dedicated server to test the restores

Also, as reindexing cycle takes several month, and business is quickly growing and we have more data, there are too many variables.

At least we keep all SLAs with growing amount...

We had reversed organic databases growth, so Used space in a database, which steadily increased, dropped sharply in few month. So I had bought 1-2 years of life on the...

• This reply was modified 1 year, 1 month ago by  tzimie.
• This reply was modified 1 year, 1 month ago by  tzimie.
• This reply was modified 1 year, 1 month ago by  tzimie.

When I metioned NetApp, it was on a previous job where I had hunderds of servers with small databases

On a new job with VLDBs and 80Tb we use NetApp just...

• This reply was modified 1 year, 1 month ago by  tzimie.

I used Vmware+NetAPP level instant backups

They are great until your databases are small, <200-500Gb

With that workload, our servers are bare metal. Local SSD for data and NVMe for tempdb. Because...

I am aware of that effect. We do update stats which changes (sometimes) execution plans

We monitor Query Store a lot for regressed queries and check for execution plans change.

As you...

I am using COMPRESSION=PAGE

Even without COMPRESSION, tables become 1.5-2 times smaller after rebuild

With the compression, below is the extract from the output of my script. You can see, sometimes tables...

We are using 4 backup files on NetApp in the same datacenter

network is two 10gbs adapters bridged

all other settings are default

We had an isse when HADR was locked by user transactions and vice versa

It happened soon after we upgraded from Standard edition to Enterprise and started to use Resource Gov.

But...

Hm. Some of our databases are 20Tb. Total 80Tb on one server, takes more than a day for full backup.