search

flatrick / troubleshooting

Tips for how to troubleshoot different aspects of applications
MIT License
2 stars 0 forks source link

Microsoft SQL Server #6

Open flatrick opened 4 years ago

flatrick commented 4 years ago

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 commented 4 years ago

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

flatrick commented 4 years ago

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

flatrick commented 4 years ago

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

flatrick commented 4 years ago

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