Slow database

Chaitanya Kiran 101 Reputation points
2021-05-12T14:47:38.757+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,231 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 98,751 Reputation points
    2021-05-12T21:41:07.353+00:00

    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.

    0 comments No comments

  2. AmeliaGu-MSFT 13,956 Reputation points Microsoft Vendor
    2021-05-13T07:01:17.917+00:00

    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.

    0 comments No comments