There is an issue on my production SQL Server. There is not any blocking on the server but it doesn't respond in acceptable time. For example, I execute the
sp_who3 procedure to watch what is going on the server, but the execution time goes to 4, 5 minutes.
I noticed the issue occured when my temdb disk drive was under 10%.
160 Gb RAM
18 Core CPU
What should I do? I don't know what to do now.