Post reply

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

  • March 16, 2019 at 7:25 am

    #416878

    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. SS2017 has NO databases as I just finished setup. 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 takes 390 MB in Windows Task Manager for the process

    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 (i.e. open Firefox) 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.
    thx

    --
    candide
    ________Panta rhei

  • March 16, 2019 at 7:53 am

    #2024691

    I would say its not so much the SQL but the VM and the Host config that matter.

    How many CPU's does the Host have and how many are assigned to the VM - and are the vm's oversubscribed or not? this both for memory and cpu.

    in any case 4GB is way too low for all the things you have on that vm. Just sharepoint requirements are 12 GB on its minimal configuration.

  • March 18, 2019 at 10:42 am

    #2024796

    Does the VM has Vmware Guest tools installed? Otherwise the VM is slow because the VMWare host has to emulate everything (hardware etc) with cpu power. Installing the tools: https://kb.vmware.com/s/article/1018377

  • March 19, 2019 at 2:31 am

    #2024866

    My PC has 1 CPU with 4 Cores and 16GB RAM. As frederico_fonseca recommended I increased the memory for the VM to 12 GB.
    Inside the VM there is used 2,6 GB from 12 GB = 21% of the RAM. OK and now when I open browser etc. I can work inside this VM 😀
    and I don't here the HDD scratching anymore when desktop is resting - fine!
    @jo-2: do you mean VMware Tools? These are installed.

    --
    candide
    ________Panta rhei

  • March 20, 2019 at 4:12 am

    #2024983

    Thanks for the update

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply