you have deadlock between 2 similar processes running

(@p__linq__0 nvarchar(4000),@p__linq__1 nvarchar(4000),@p__linq__2 int,@p__linq__3 int)SELECT ...

and

(@p__linq__0 nvarchar(4000),@p__linq__1 int)SELECT TOP (1)...

from .net on dbid =14

As 2 selects in read committed mode dont lock each...

• This reply was modified 3 months, 2 weeks ago by tzimie.

start from this

select name,log_reuse_wait_desc from sys.databases

what do you see for the db where you have a  problem?

No, backups do not cause the deadlocks. As it happens at night, check other jobs, likely you have index rebuild/reorg, update stats etc. These jobs are more likely to cause...

• This reply was modified 3 months, 2 weeks ago by tzimie.

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, 11 months 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, 11 months ago by tzimie.
• This reply was modified 1 year, 11 months ago by tzimie.
• This reply was modified 1 year, 11 months 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, 11 months 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.