Is backup compression enabled on the SQL 2016 server?

What is the error that the application reports?

You do have to wonder if someone is maybe a little out of their depth trying to use SQL Server, when they post photos (not screenshots) of computer's...

Yes, but if you do the following:

• toggle menu on
• maximize screen

You can't then toggle the menu off, as the menu on/off button has disappeared...

You could label them as follows:

SELECT 'GCDF_DB', [Actives] FROM [GCDF_DB].[dbo].[vTotalActives] as "Actives GCDF"
UNION ALL
SELECT 'ACS_DB', [Actives] FROM [ACS_DB].[dbo].[vTotalActives] as "Actives ACS"
...etc

...etc

Please note that database diagrams are deprecated, and are not accessible in SSMS 18.

https://docs.microsoft.com/en-gb/sql/ssms/release-notes-ssms?view=sql-server-2017#deprecated-features-1

Do the error logs indicate which script was causing the error?  Because those scripts are all available to run in the SQLServer\MSSQL\Install folder.

"But!" I hear you cry, "I can't even...

What else is running on the server?  Is it dedicated to SQL Server, or are there other processes there such as SSRS, SSAS, your application, AV, endpoint protection, somebody logged...

I misread that...

Use the MAXDOP query hint?  That can go above the configured value as well as below...

https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=sql-server-2017

Fingers crossed this all goes smoothly!  Let me know if I can help with testing