Forum Discussion

Stefan Fey's avatar
Stefan Fey
Copper Contributor
Mar 13, 2019
Solved

"SQL Server Windows NT - 64 bit" in Task Manager: CPU high

hi, I have setup a new VM (VMware) with latest Windows 2019 Server Standard (as domain), Sharepoint 2019 Enterprise and SQL Server 2017 Dev.Edition. This VM is for test purposes only and I know, for...
  • yavuzfilizlibay's avatar
    yavuzfilizlibay
    Mar 27, 2019

    Stefan Fey Sharepoint wants more ram, sharepoint and SQL Server are in the same machine they dont work well

    You can check SQL Server ram at perfmon - SQL Server buffer manager counter 

Anonymous's avatar
Anonymous
Apr 01, 2019

Hello,

 

    Could you please check out the "Max Degree of Parallelism" configuration value for SQL Server. 
Best practices for Sharepoint; you should set the "Max Degree of Parallelism" configuration value to 1 for SQL Server.

    I think, if you are able to separate products each other on your system, you will get better results.

 

Have a nice day,

 

 

 

Stefan Fey 

  • Stefan Fey's avatar
    Stefan Fey
    Copper Contributor
    Apr 02, 2019
    solved - look link above thx

Resources