question

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

Slow database

I have a database. It is responding very slowly. What are the steps to resolve this issue

sql-server-general
· 2
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.

Databases are not slow, queries against may are, but with that less information it's difficukt to assist here, so please provide more informations.

0 Votes 0 ·

Hi @ChaitanyaKiran-9853,
How are things going on? Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

First step is to get more detailed information of what exactly is slow. If you are on SQL 2016 or later, Query Store is a great tool for this.

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.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi ChaitanyaKiran-9853,
In addition, you also can use SQL Server Profiler or Extended Events to create a trace to capture information about running query, including CPU, Reads, Writes and Duration. For SQL server Profiler, we can click on the "Event Selection" tab and check RPC:Completed and SQL:BatchCompleted events.

96282-01.jpg

For Extended Events, we can select the rpc_completed and sql_batch_completed events.
Then we can start the troubleshooting, and use the execution plan and statistics to identify queries that need tuning and indexes that need creating.
Please refer to this article which might help.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



01.jpg (20.7 KiB)
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.