Microsoft SQL Server

[flatrick]

If you're working with SQL Server, you need to become aquainted with Brent Ozar and his SQL-scripts.

Depending on your relationship with the developers of the application (and what your own role is), by running sp_blitz and the other scripts Ozar provides, you might uncover some simple changes to improve the performance for a application

sp_Blitz
sp_BlitzFirst
sp_BlitzWho

[flatrick]

https://stackify.com/performance-tuning-in-sql-server-find-slow-queries/

[flatrick]

https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15

[flatrick]

https://www.mssqltips.com/sql-server-tip-category/9/performance-tuning/

[flatrick]

https://www.mssqltips.com/sqlservertip/2890/detect-sql-server-cpu-pressure/