Tuesday, October 30, 2012

SQL 2008 R2 SP1 supported for vCenter 5.0

A couple of weeks ago, I was designing a VMware vSphere environment, when just checking the Interoperability Matrixes for the supported versions of Microsoft SQL for vCenter 5.0, I realized the Service Pack 1 for Microsoft SQL 2008 R2 was not supported.
I though it very disturbing, SP1 has been released several months ago, there’s no way it  still not supported !!
I decided to look for some more information internally.
My first find was several testimonials from others VMware consultants that have implemented successfully with that version.
Then I contacted the project manager, which has been in charge for the release of vCenter, she has confirmed me that this version (SP1) has been tested and it’s supported to work with vCenter 5.0 Update 1 a/b.
WOW, hold on to your hat…that’s the trick part:
Microsoft SQL 2008 R2 SP1 is just supported for vCenter 5.0 Update 1 a/b. (pay attention to releases a and b)
** Just to make sure. Microsoft SQL 2008 R2 SP1 IS NOT SUPPORTED on vCenter 5.0 Update 1. If you want to use this version of SQL, update your vCenter to version a or b.
To help you guys identify which version of vCenter you are running at, those are the build numbers you should be looking at:
vCenter 5.0 U1 b – Build Number 804277
vCenter 5.0 U1 a – Build Number 757163
vCenter 5.0 U1    Build Number 623373

So, where did come all this mess from ?
Taking a second look at Interoperability Matrixes, I realized it does not list the releases A or B.

Right now I’m working internally to have this matrix updated.
I hope this post help some of you guys when deciding what database version to choose.


Friday, October 19, 2012

CPU utilization over 100%

This week my client faced a weird situation, the CPU utilization of theirs ESXi host were over 100% !!!

Just as informational, the high utilization on their VMs, which caused the hosts to have a high CPU utilization, was not VMware related ; )

We know the hosts were in a high utilization period, but how was be over 100% possible ?

I started looking at vSphere Monitoring andPerformance, on page 49 I found a nice description of the CPU utilization.

The note on that description gave me the first clue

NOTE If a PCPU is running at frequency that is higher than its nominal (rated) frequency, then PCPU USED(%) can be greater than 100%.
Now that I confirmed that it’s possible, I decided to look for what could be allowing that.
Very soon I figured out that it’s a feature on Intel processors called Intel® Turbo Boost Technology.
When it’s enabled it allows the processor to transition to a higher frequency in order to give more horsepower during peak periods.
 I hope you don’t have to face extreme situations like this, but if you do that’s how you explain it to your boss.

Who am I

My photo
I’m an IT specialist with over 15 years of experience, working from IT infrastructure to management products, troubleshooting and project management skills from medium to large environments. Nowadays I'm working for VMware as a Consulting Architect, helping customers to embrace the Cloud Era and make them successfully on their journey. Despite the fact I'm a VMware employee these postings reflect my own opinion and do not represents VMware's position, strategies or opinions. Reach me at @dumeirell

Most Viewed Posts

Blog Archive