+ Post New Thread
Results 1 to 7 of 7
Thin Client and Virtual Machines Thread, 2003 Server HyperV Client 100% CPU in Technical; Hi, Our SIMS server is visualised (p2v) running on 2008 R2 HyperV Host Server. The host server has 32Gb RAM ...
  1. #1
    HCC
    HCC is offline
    HCC's Avatar
    Join Date
    Jan 2009
    Location
    East Sussex
    Posts
    117
    Thank Post
    9
    Thanked 0 Times in 0 Posts
    Rep Power
    13

    2003 Server HyperV Client 100% CPU

    Hi,

    Our SIMS server is visualised (p2v) running on 2008 R2 HyperV Host Server. The host server has 32Gb RAM and dual processors with 16 cores available.

    The SIMS Server runs at 100% CPU most of the time which makes SIMS.net really sloooow. I've checked in the task manager and it is the SQL process (sqlservr.exe) that is the cause. Yet when I look at the host task manager it never goes over 2-3% cpu on any core. So the host processing power is not being passed to the guest.
    The guest already has the max 4 logical processors and being 2003 x86 std I can't give it more than 4Gb RAM.

    I've got to move SIMS over to a new 2008 x64 R2 server in the summer (which I hope would have better performance, being optimised for virtualization).
    Is there anything I can do to speed up this 2003 virtual machine in the meantime?

    Thanks,

  2. #2

    Join Date
    Jun 2008
    Posts
    745
    Thank Post
    121
    Thanked 70 Times in 57 Posts
    Rep Power
    33
    I think you need to set a max level of memory it can consume through the SQL Management Tool. How to do this I'm exactly unsure of.

    I run Win 2003 SP2 STD with SIMS.Net in a VM using VMware ESXi. I've only given it 2 processors/cores and 3GB RAM and I've not noticed any degradation.

    I know it doesn't help but hopefully someone will be able to tell you about the management tool.

  3. 2 Thanks to Chuckster:

    HCC (16th June 2011), irsprint84 (16th June 2011)

  4. #3
    HCC
    HCC is offline
    HCC's Avatar
    Join Date
    Jan 2009
    Location
    East Sussex
    Posts
    117
    Thank Post
    9
    Thanked 0 Times in 0 Posts
    Rep Power
    13
    Hi,

    I think it's more about the CPU than the RAM but anyway...

    I've found the settings as per Suggested Max Memory Settings for SQL Server 2005/2008 - Glenn Berry&#39s SQL Server Performance - SQLServerCentral.com

    It was set to 2147483647 Max server memory. I've set this to 3500 as suggested since the server can't see any more than 4Gb.

    So far not much difference, but thanks for the suggestion.

  5. #4

    Join Date
    Apr 2008
    Posts
    853
    Thank Post
    111
    Thanked 112 Times in 108 Posts
    Rep Power
    46
    Quote Originally Posted by Chuckster View Post
    I think you need to set a max level of memory it can consume through the SQL Management Tool. How to do this I'm exactly unsure of.

    I run Win 2003 SP2 STD with SIMS.Net in a VM using VMware ESXi. I've only given it 2 processors/cores and 3GB RAM and I've not noticed any degradation.

    I know it doesn't help but hopefully someone will be able to tell you about the management tool.
    Yeah this post is correct, also check in backup is full or simple

  6. #5
    HCC
    HCC is offline
    HCC's Avatar
    Join Date
    Jan 2009
    Location
    East Sussex
    Posts
    117
    Thank Post
    9
    Thanked 0 Times in 0 Posts
    Rep Power
    13
    How do I find out which way the backup is set up? All I know about the backup is that there is a maintenance plan that runs a backup each night and tidies up the number of copies.

  7. #6

    Join Date
    Apr 2006
    Posts
    390
    Thank Post
    24
    Thanked 95 Times in 61 Posts
    Rep Power
    45
    Be careful setting the amount of RAM allocated to SQL, as if you set it too high then you run the risk that SQL Server will rob RAM from the OS. Then things will get REALLY slow. HCC, note that the table in that article is for x64 machines, which would see a full 4Gb of RAM. There's some interesting stuff about RAM limits in the comments section ("I am going to write another post that covers x86"), which I think will explain why upping your limit to 3.5 Mb won't appear to make a difference.

    High CPU on DB servers can hint at index problems - not familiar with SIMS, does it ship with any utilities or recommendations for reindexing or checking the indexes?

  8. #7

    Join Date
    Apr 2006
    Posts
    390
    Thank Post
    24
    Thanked 95 Times in 61 Posts
    Rep Power
    45
    Sorry, obvious question - what was the performance like before the p2v, or do you not have stats for that?



SHARE:
+ Post New Thread

Similar Threads

  1. CPU 100% but don't know why...
    By enjay in forum Windows
    Replies: 2
    Last Post: 16th September 2010, 11:43 AM
  2. 100 Core CPU
    By mac_shinobi in forum Hardware
    Replies: 3
    Last Post: 28th October 2009, 08:41 PM
  3. Citrix Presentation Server with 100% CPU Usage
    By jack0w in forum Windows Server 2000/2003
    Replies: 0
    Last Post: 9th October 2009, 01:15 PM
  4. Server CPU Usage at 100%
    By DSapseid in forum Windows
    Replies: 14
    Last Post: 5th December 2008, 11:07 PM
  5. CPU on server at 100%
    By kennysarmy in forum Windows
    Replies: 5
    Last Post: 16th March 2008, 11:55 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •