SQL Server Database Not Responding

Question

Hi All,

I am using the SQL server 2017 standard edition in my production. My production database size is now 380GB. Since yesterday I am facing too much slow response from the SQL server. After a server restart SQL server service is running but when I open SSMS, in SSMS database directory is not expending. From the query window, my select statement is also not executing. I can create a test database in the instance. I tried to restore the database from the backup file, unfortunately, database restore was successful but the same condition again, in the SSMS database directory, is not expending and I can't run any simple select statement and SQL server is hung. After the reinstall, the SQL server problem is not solved.

Please help to solve this issue.

Answer 1

There is not very much information to work from, but let's try to narrow down the problem. If you restore a backup on a different server, is it still slow? If it is not, we can suspect that the problem is with the server itself.

In that case I would check the SQL Server error log on this machine for interesting error messages. I would also check in Task Manager if there are any processes running which should not be there. Not the least processes that consume a lot of CPU or a lot of memory.

Also, very important, are all queries slow, or only some specific operations?

Answer 2

That's very less on information.
Have you checked CPU, I/O and memory utilization on the server? Can you work normally with any application on the server, like using Notepad to open a text file with e.g. a size of 1 MB?

Answer 3

Hi @ukhore ,

In addition, could you please use exec sp_who2 to see if there are any blocking?
Please refer to How to identify blocking in SQL Server 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.