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/
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
If users complain that application is very slow, what all things should we check? The first thing that comes to my mind is blocking.
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/
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.