SQL Server 2019 Retreive Data very slow

Question

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.

Answer 1

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

Answer 2

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?