question

ChaitanyaKiran-2787 avatar image
0 Votes"
ChaitanyaKiran-2787 asked AmeliaGu-msft commented

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

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

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

0 Votes 0 ·

Would like to know the troubleshooting approach

0 Votes 0 ·

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 Votes 0 ·
chbernard avatar image
0 Votes"
chbernard answered
5 |1600 characters needed characters left characters exceeded

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

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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

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