since the correct final answer is impossible to say without IOPS, brand specs, etc. I'll say

Tempdb on ssd.

There.

20 seems high, but your real issue is the scans (as you already know).

Are the indexes and stats being created, maintained, reviewed and altered as appropriate?

It totally depends on the IOPS of each storage, and your performance testing.

Have you allocated files properly for tempdb, etc?

FWIW, if its a backup, it will typically end with .bak extension. For databases files, you will generally see an .mdf and an .ldf file for basic...

Can't speak to your issue directly, but a number of different sessions at PASS Summit this year pointed out that changing the compat level from 120 to 130 (or the...

Since the services are what you are really looking for, you will see all of them for each Server you query.

If you search for SQL Server Service on YourServer0546, which...

stepping back...since you've been troubleshooting for a week on three different sites, might I suggest either opening a case with MS, or re-initializing. The re-publishing thing will make...

It may sound a bit-self serving, but if you have a server list in a text file, you can loop through that quite easily using Lowells commands coupled with techniques...

SQL VM as noted above has two different ways to pay. You pay while the VM shows anything other than 'Deallocated' in the Azure Portal. Turn off...

As far as I've ever seen, the alignment is done in the presentation layer...Excel, SSRS, etc. SQL just pushes the data...

Sign up for the free/limited Azure account and start learning the Azure Portal, how to create a VM (with or without SQL preinstalled), how to create an Azure SQL Database,...

Please explain what you mean by Replication (many use the term generically).

Microsoft Replication is built into SQL Server and will replicate to both another SQL Server as well as an...

ROFL :-D:-P;-):w00t::cool:

There are situations where (not very flexible) maintenance...

There are some limitations and such listed here:

SQL Server 2016 Support for SQL Server 2005

Mainstream support for Windows 2008 R2 has ended, extended support in 2020...any chance you can build a cluster with current versions and migrate to that? Just a thought,...