Application very slow

Question

question

ChaitanyaKiran-2787 asked Oct 21, '21 AmeliaGu-msft commented Oct 22, '21

Application very slow

If users complain that application is very slow, what all things should we check? The first thing that comes to my mind is blocking.

sql-server-general

· 3

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NilssonFredrikK-3135 · Oct 21, 2021 at 12:08 PM

You need to provide more information my friend, this is like asking my computer is not working, what should I check?

0 ·

ChaitanyaKiran-2787 NilssonFredrikK-3135 · Oct 21, 2021 at 12:40 PM

Would like to know the troubleshooting approach

0 ·

AmeliaGu-msft · Oct 22, 2021 at 06:54 AM

Hi ChaitanyaKiran-2787,

Please also refer to this article to check for any network issues and application issues that are causing SQL Server application performance issues.

Best Regards,
Amelia

0 ·

Answer 1 · 2021-10-21T12:20:37.717Z

chbernard answered Oct 21, '21

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/

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2021-10-21T21:51:48.233Z

ErlandSommarskog answered Oct 21, '21

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.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question