CPU usage graduately go up

Question

CPU usage graduately go up

susan smith-491419

SSC Enthusiast

Points: 127
More actions
April 15, 2008 at 7:10 am

#71146

I managed 10GB SQL server 2000 database on windows server 2003 with service pack2. Before it was moved to VMware, CPU usage (from windows task manager) was about 20%. after it is in VMware, CPU graduately went up as high as 80% over the time. My network administrator told me the processor was reached alert level. After I stopped and restarted the application which accesses the SQL database. CPU usage went down to 2%-5% and graduately went up again over the 1- 2 weeks to 80% again. We are new with VMware and could not find any solution to solve this issue. any other suggestions are welcome,thanks

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

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

Kevin-458339 SSCrazy Points: 2717 More actions · Answer 1

Hi

I am not sure on your VM environment - but we had similar problems during our testing phase and we had the following issues:

* Licensing

* Virtual Servers being moved to other physical systems

* Hardware errors

Licensing

----------

This issue was due to our license not being the correct version - or a eval versus a full version and the amount of CPU's or maximum CPU GHZ that could be used was 1GHZ. After correcting this all went better.

VM Moving Physical Boxes

-----------------------------

In the event that a VM server got too busy on one of the 7 physical servers - the VM software started moving the server to another physical box and this caused additional CPU / server strain during this migration period (we even had a slight connection issue during these migrations)

Physical Hardware Problems

-------------------------------

One of our servers in our VM environment had problems with the main-board / bios that needed to be replaced - but this caused performance issues - but was very difficult to identify.

Let us know if you find the cause

Thanks

Kevin

susan smith-491419 SSC Enthusiast Points: 127 More actions · Answer 2

Hi, Kevin. Thanks you for the response.

Could you give me more detail information on the reason you listed here?

In the our VM enviroment, 2 SQL servers share the same blade. The CPU on one of them is always about 20%. Other graduately went up to 80%. I am wondering the second reason listed "Virtual Servers being moved to other systems". how did you identify this?

Thanks

Kevin-458339 SSCrazy Points: 2717 More actions · Answer 3

Hi

We are using HP servers in a cluster - in our current environment there are 7 HP DL585 - the software that we use is ESS (i am not sure the version etc).

There are 2 options for the VM environment to either:

* Automatically move Virtual Server systems between physical hardware boxes to try get better resources

* Manually move the Virtual Servers between physical hardware boxes

Maybe the software that we are running is different to what you have.

I will try get the exact name, version etc

Thanks

Kevin

susan smith-491419 SSC Enthusiast Points: 127 More actions · Answer 4

The problem was solved.

The application which accesses to SQL has a module to check the data constantly. After it was changed to connect to sql every 10 second. see the CPU went back arond 10% and remains the same over the time.

Thanks for the response. VM certainly behave differetly than the physical SQL server.