Hello ,

Thank you . that was the issue.

Hello ,

Would you please recommend the Value of MAX DOP  ?

There are  2 Numa Nodes : one contains 8, the other 24 CPUs

Hello ,

Thank you so much really appreciated it,  one last question so no need to restart the service.

Hello ,

Thank you . I will check the book

I found the  max server memory == > 2147483647 MB

for now, Shall Preallocate SQL transaction log? Are there options to decrease that...

Hi -

I attached the pics .

Hello ,

Thank you so much, solved.