As a suggestion, set the Compatibility level to SQL 2014 to see if the performance returns to pre-upgrade levels. If so, note the significant changes between 2014 and 2019 and...

• This reply was modified 1 years, 6 months ago by Meet George Jetson.

Your supplied screen shot shows SQL Server 11.0.2218.0 (which is SQL Server 2012) is what you are connected.

Question to some of the panel, would setting the DEADLOCK_PRIORITY  be an option?

Is the action, coming from the application server, a query that can be ran manually ON the actual SQL server?  This will let you see how quickly SQL is returning...

This was the most timely post.  Just this past weekend, my cell phone took a "forty foot free fall face plant" from the upstairs deck to the paved patio below. ...

What was the fix?

master, tempdb, msdb, model

I second Jeffrey's suggestion, with the addition of compressing the backup after you've created it. The end user would probably appreciate this time and space saving extra step.

Mark Nash wrote a great "How to" right here on SSC

http://www.sqlservercentral.com/articles/Monitoring/monitoringdriveanddatabasefreespace/1415/

I did not think you needed a license for a Developer environment

Script it, much cleaner:

Use Master

Alter Database [DATABASE_NAME_HERE]

SET SINGLE_USER With ROLLBACK IMMEDIATE

RESTORE DATABASE [DATABASE_NAME_HERE] FROM DISK 'X:\backup\DATABASEBACKUPFILE.bak'

WITH REPLACE

GO

There is an orphaned key in the registry, which one is impossible for anyone on this site to guess. Your best bet is to download a registry cleanup tool.

SQL Server 2008 R2 Express is NOT the same thing as SQL Server 2008 R2...

Are there any Trace Flags enabled in SQL Server startup parameters? If I recall correctly, there is one that suppresses logging.

Have you tried creating a virtual Server 2000/2003 environment on your Windows 7 box that you could install SQL 2000 SP4 on? Just a suggestion.