Share via

SQL Server 2019 Retreive Data very slow

Prashant Chavan 1 Reputation point
2020-08-29T10:57:12.6+00:00

I have issue in retrieve the Data from Table it is taking at least 1 hr for showing normal Select top 100 * from Table_Name.
In my table forty million one hundred twenty-three thousand one hundred six Rows(40123106) and Daily two million seven hundred sixty-four thousand eight hundred(2764800)Rows New Data stored.
I am Using SQL Server 2019.
Can any tell me how i can make it faster. as report is not Responding for 3 4 Hrs.
Thanks in Advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,187 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 13,966 Reputation points Microsoft Vendor
    2020-08-31T06:37:19.187+00:00

    Hi PrashantChavan-6623,

    You can execute sp_who2 or sp_WhoIsActive to see if there is any blocking.
    Secondly, you can check the execution plan and SQL Server Profiler for the query and see if there are any problems.
    Please refer to the following articles which might help you to troubleshooting query:
    Troubleshoot Slow-Running Queries In SQL Server
    How to identify slow running queries in SQL Server

    Best Regards,
    Amelia

    0 comments
  2. Norm C 6 Reputation points
    2020-09-02T20:24:35.117+00:00

    If your issue is one where nothing has changed in your system but there's an issue today, it's possible your statistics may be stale causing the SQL Server to have trouble.

    Update Statistics to your table to see if that helps?

    0 comments