SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-366935%22%20slang%3D%22en-US%22%3E%22SQL%20Server%20Windows%20NT%20-%2064%20bit%22%20in%20Task%20Manager%3A%20CPU%20high%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-366935%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%3C%2FP%3E%3CP%3EI%20have%20setup%20a%20new%20VM%20(VMware)%20with%20latest%20Windows%202019%20Server%20Standard%20(as%20domain)%2C%20Sharepoint%202019%20Enterprise%20and%20SQL%20Server%202017%20Dev.Edition.%20This%20VM%20is%20for%20test%20purposes%20only%20and%20I%20know%2C%20for%20production%20at%20least%20the%20SQL%20Server%202017%20should%20have%20its%20own%20VM%20-%20but%20I%20tried%20it%20this%20way.%3C%2FP%3E%3CP%3EAfter%20installing%20SS2017%20there%20is%20a%20high%20CPU%20consumption%20(50-80%25)%20and%20RAM%20390%20MB%20in%20Windows%20Task%20Manager%20for%3C%2FP%3E%3CP%3E%3CSTRONG%3ESQL%20Server%20Windows%20NT%20-%2064%20bit%20-%20SQL%20Server%20(MSSQLSERVER)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EI%20found%20some%20tips%20regarding%20Memory%20for%20%22server%20properties%20-%20RAM%20-%20maximum%22%20which%20has%20a%20default%20value%20of%202147483647%20and%20what%20I%20changed%20to%202000%20(MB).%3C%2FP%3E%3CP%3EThe%20host%20PC%20got%2016%20GB%20of%20Hardware-RAM.%20The%20VM%20itself%20got%204%20GB%20RAM%20so%20half%20of%20it%20maybe%20used%20by%20SS2017.%3C%2FP%3E%3CP%3EBut%20still%20any%20windows%20need%20some%20time%20to%20open%20or%20react%20on%20mouse%20click.%3C%2FP%3E%3CP%3EAs%20this%20is%20a%20totally%20new%20install%20I'm%20asking%20myself%20if%20someone%20got%20a%20solution%20for%20slow%20reaction.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-392886%22%20slang%3D%22en-US%22%3ERe%3A%20%22SQL%20Server%20Windows%20NT%20-%2064%20bit%22%20in%20Task%20Manager%3A%20CPU%20high%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392886%22%20slang%3D%22en-US%22%3Esolved%20-%20look%20link%20above%20thx%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-392118%22%20slang%3D%22en-US%22%3ERe%3A%20%22SQL%20Server%20Windows%20NT%20-%2064%20bit%22%20in%20Task%20Manager%3A%20CPU%20high%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392118%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20Could%20you%20please%20check%20out%20the%20%22Max%20Degree%20of%20Parallelism%22%20configuration%20value%20for%20SQL%20Server.%26nbsp%3B%3CBR%20%2F%3EBest%20practices%20for%20Sharepoint%3B%20you%20should%20set%20the%20%22Max%20Degree%20of%20Parallelism%22%20configuration%20value%20to%201%20for%20SQL%20Server.%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20I%20think%2C%20if%20you%20are%20able%20to%20separate%20products%20each%20other%20on%20your%20system%2C%20you%20will%20get%20better%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20a%20nice%20day%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F17721%22%20target%3D%22_blank%22%3E%40Stefan%20Fey%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389370%22%20slang%3D%22en-US%22%3ERe%3A%20%22SQL%20Server%20Windows%20NT%20-%2064%20bit%22%20in%20Task%20Manager%3A%20CPU%20high%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389370%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F17721%22%20target%3D%22_blank%22%3E%40Stefan%20Fey%3C%2FA%3E%26nbsp%3BSharepoint%20wants%20more%20ram%2C%20sharepoint%20and%20SQL%20Server%20are%20in%20the%20same%20machine%20they%20dont%20work%20well%3C%2FP%3E%3CP%3EYou%20can%20check%20SQL%20Server%20ram%20at%20perfmon%20-%20SQL%20Server%20buffer%20manager%20counter%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-386402%22%20slang%3D%22en-US%22%3ERe%3A%20%22SQL%20Server%20Windows%20NT%20-%2064%20bit%22%20in%20Task%20Manager%3A%20CPU%20high%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386402%22%20slang%3D%22en-US%22%3Esee%20also%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.sqlservercentral.com%2FForums%2F2024405%2FSQL-Server-Windows-NT-64-bit-in-Task-Manager-CPU-high%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.sqlservercentral.com%2FForums%2F2024405%2FSQL-Server-Windows-NT-64-bit-in-Task-Manager-CPU-high%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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 production at least the SQL Server 2017 should have its own VM - but I tried it this way.

After installing SS2017 there is a high CPU consumption (50-80%) and RAM 390 MB in Windows Task Manager for

SQL Server Windows NT - 64 bit - SQL Server (MSSQLSERVER)

I found some tips regarding Memory for "server properties - RAM - maximum" which has a default value of 2147483647 and what I changed to 2000 (MB).

The host PC got 16 GB of Hardware-RAM. The VM itself got 4 GB RAM so half of it maybe used by SS2017.

But still any windows need some time to open or react on mouse click.

As this is a totally new install I'm asking myself if someone got a solution for slow reaction.

4 Replies
Highlighted
Solution

@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 

Highlighted

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 

Highlighted
solved - look link above thx