VMWARE CPU Erractic

I have a Poweredge 2850 with 2 vm guests running.  Raid 10 with 2 Dual Core Xeon processors 3.2 GHZ. Server1 runs perfect with steady cpu usage. Server2 runs like he..hockey sticks.  Server2 is running sql.  Has 4 gig ram.  I have 1 core allocated per vmguest.  Server2 spikes ever 10-15mins and make the fans on the server run 10-12 rpm and hold there for 5 mins at least.  If I add more cores to the server2 the fans will stay at a constant 10k and never come down.  I have added a pdf for viewing of the cpu usage.  Any help would be great.  Pulling my hair out.  I also have server 2003 running on a stand alone 2850 and it is perfectly well.  No heat issues in the cabinet.  Some thing server 2 is spiking the cpu.  Has any one seen this before???  I did notice the sql was eating 1.5gigs of ram so I upped the ram to 4 gigs.  Still no help.  Is there and idle hard drive issue I don't know about????
bjewell03Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bjewell03Author Commented:
Sorry here is the attached file.
0
bjewell03Author Commented:
0
vmwarun - ArunCommented:
1.What version of SQL are you running and how many DB instances are being served by this VM ?
2.How many concurrent connections are made to the VM ?
3.What OS is running within the VM hosting the SQL DB ?
Simply adding more vCPUs to the VM will only add fuel to the fire.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Paul SolovyovskySenior IT AdvisorCommented:
Update the BIOS, or at least check the bios level on the two servers
0
bjewell03Author Commented:
Windows server 2000 Running SQL Server 2000 with only 1 Database.  At the most maybe 11 concurrent connections.  Both 2850 servers have A07 bios.
0
vmwarun - ArunCommented:
1.How many physical NICs does the ESX Host have and how have you configured networking for the VMs ?
2.Are you running any anti-virus/security software in the VM ?
 
0
bjewell03Author Commented:
1 nic.  no antivirus software.  I have cut just about every thing out running except sql. I have scanned for viruses.  Just now only 4 connections were made to the server and it spiked.
0
CrashDummy_MSCommented:
On the SQL VM, look in SQL Enterprise Manager look at the maintenance jobs and see if anything is scheduled every 15 minutes.

One problem I had when I moved some SQL servers to VMware at work was that there were transaction backups every hour, which is fine, but someone had check the option to run a full integrity check every time it backed up transaction logs, when just running that once a day when the full backups ran at night would be fine. This it slow down for a few minutes every hour when it backed up logs. No once noticed when it was a physical server because it had so much extra resources to waste, but things have to be set up a little more efficiently on VMs.
0
Naga Bhanu Kiran KotaCommented:
hi

have you ensured that the vmware tools on the machine are at version 7(vspher 4). Is this SQL machine running all relevant windows upgrades.

as crashdummy has suggest you need to see if there is any kind of activity that is being triggered every 15 mts or 10 mts as well.

regards
bhanu
0
bjewell03Author Commented:
I have noticed that if no one is using the sql database the system runs stable.  As soon as connections are made that is when it will spike the cpu and the fans take off like a jet.  It does not do it after everyone is out.
0
CrashDummy_MSCommented:
I wasn't near my desktop earlier but I'm looking at one of my SQL 2000 boxes now. In Enterprise Manager, browse down through the options to Management, SQL Server Agent, and click Jobs. Look at the Next Run Date column. Find jobs that will be running again shortly, see if their last run status was within the last 15 minutes.

If you can't find a scheduled job that's causing it, it could be whatever applications are accessing SQL, or could be the users creating overly broad searches. One app we use took about 3 minutes to complete a query, and when we had the users be a little more specific about what fields were searched it only takes a couple of seconds now.
0
bjewell03Author Commented:
Crash,
I drilled down and all my jobs are set to run at 12 am or 1am.  Hard to imagine this server does not have the umph to push these apps.
0
CrashDummy_MSCommented:
Ok, so probably nothing wrong with the jobs then.

It just has one vCPU assigned right? I know arunraju said that adding more can actually slow things down, and it can, but I think in your case it won't cause any problems. The problem with multiple vCPUs comes more when you have more vCPUs assigned than the number of real CPU cores you have. You've got 2 dual-cores, so 4 cores total, and only 2 cores in use, so if you give SQL 2 vCPUs you're not likely to run into any issues. At the very least, it's worth trying.

If adding a 2nd vCPU doesn't help, my next question would be do the users notice a slowdown or just you wen you are logged into the VM and/or looking at the CPU usage? If the users don't say it's slow, it may be fine just the way it is.
0
bjewell03Author Commented:
There isn't any lag what so ever on the users end.  My main issue is if I simply rdp in to the system or when one or multiple users use sql, or might I say put "ANY"  kind of load on the server, the cpu will spike a moment to 75 or 100 percent, then the fans kick in to 10-12k rpm.  I have tried to allocate 2 cpu's to server2 and I have even told it to use specific cores that are not supposed to be used by the other vm.  I upped the ram from 2gig to 4 gig and still no help.  Its like any little load put on that specific vm make my host think it is doing double duty and pumps the fans.
0
Naga Bhanu Kiran KotaCommented:
hi biewell03,

please confimr if you have already unchecked the linking of CPU cores and set the VM with a single CPU and verified the behaviour

if you have not done the same can you do that and verify. If the same behaviour is seen then i think this would need be verified by VMware as to why this behaviour is seen. Can you also verify if the VMware tools are running properly on this machine and if possible uninstall the vmware tools completly and reboot and verify the behaviour.

Regards
Bhanu
0
bjewell03Author Commented:
Well to update everyone, I have moved my vm's to an PowerEdge 1850 for temp purposes.  The 1850 does not replicate the same issues as the 2850 I am running.  Before I moved my vm's I made sure all bios and BMC updates were done on the 1850.  So I am going to try to see if an update to the BMC on the 2850 is what will cure the problem.  
0
bjewell03Author Commented:
I have found my issue with this 2850 server.  I did do all bios and BMC updates but nothing helped.  I noticed that the server was fanning up right out of the gate at post.  So I figured I would look inside the unit once more to see if any thing was loose and low and behold, the company that put this unit together did not seat the heat sink down on one of the processors well enough.  I am totally embarrassed to have even posted this.  Thanks to all of you that tried to help.  I do want you to know that the now at least I can go through some of your steps and try to figure these out.  Sorry for the head aches.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vmwarun - ArunCommented:
I am glad you have found out the root cause.
0
Naga Bhanu Kiran KotaCommented:
hi bjewell,

the key is to find the solution and i think EE is one of the best place to find solutions posted by experts. Glad to note that you have become one of those coveted experts who can contribute in such kind of situations and hope you will come back to post your solutions for people like you who are searching for solutions based on your experience.

All the best.

Regards
Bhanu
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Components

From novice to tech pro — start learning today.