If you have activated Query Store, go into SSMS and check for top resource-consuming queries. If you haven't activated Query Store, do so, and check in a couple of hours later.
Application very slow
Chaitanya Kiran
696
Reputation points
If users complain that application is very slow, what all things should we check? The first thing that comes to my mind is blocking.
2 answers
Sort by: Newest
-
-
cristopheB 551 Reputation points
2021-10-21T12:20:37.717+00:00 See perhpas these links
sql profiler
https://stackify.com/performance-tuning-in-sql-server-find-slow-queries/how to identity sql query who are slow
https://www.sqlshack.com/how-to-identify-slow-running-queries-in-sql-server/